I hope that everyone is having a great weekend.
I am looking over some tables and index plan that is currently in place. I see some queries that use other columns that have a non-clustered index, but then also adds one column that is not in the index. The one column currently has all NULL values. I am trying to learn how an index works with NULLs. I would greatly appreciate any advice on using / creating index on a column with NULL values. I have read the BOL, but still a little uncertain about this topic.
How would this affect the performance of an index?
I greatly appreciate any and all comments/suggestions.
Thanks in advance