More Index Theory Questions

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  August 1, 2011 at 12:46 pm

  #1361776

  Where the pk is is utterly irrelevant. It's the clustered index that you need to be concerned about (the pk is clustered by default, but it's just a default)

  Maybe take a read through this series

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

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

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

  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

• BAGs

  Right there with Babe

  Points: 793

  More actions

  August 1, 2011 at 1:17 pm

  #1361803

  Thank you Gail....I will read through these.