Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index on a Column with NULLs Expand / Collapse
Author
Message
Posted Saturday, May 11, 2013 6:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:32 PM
Points: 977, Visits: 3,357
Hello Everyone
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
Andrew SQLDBA
Post #1451825
Posted Saturday, May 11, 2013 7:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 39,977, Visits: 36,339
No effect. As far as an index is concerned, null is just another value.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1451829
Posted Saturday, May 11, 2013 10:22 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:32 PM
Points: 977, Visits: 3,357
Thanks Gila
Greatly appreciate your time. You always have the answer to my odd type questions.

Andrew SQLDBA
Post #1451837
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse