Clustered Index

• ramana3327

  SSCoach

  Points: 19722

  More actions

  December 25, 2013 at 8:39 am

  #287642

  Is clustered index is good for high selectivity or low selectivity? Selectivity means no. of unique rows/ no of rows in the table but what is the density means here.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 26, 2013 at 2:00 pm

  #1676015

  http://www.sqlservercentral.com/articles/Indexing/68439/

  http://www.sqlservercentral.com/articles/Indexing/68563/

  http://www.sqlservercentral.com/articles/Indexing/68636/

  And look in Books Online, lots of material on indexes in there.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  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

• ramana3327

  SSCoach

  Points: 19722

  More actions

  December 28, 2013 at 7:40 am

  #1676216

  Thanks a lot.