June 13, 2011 at 1:08 pm
What is the rule of thumb when creating nonclustered indexes? Which fields should be part of the key and which should be included?
What's the reason NOT to make all the fields you want to put an index on part of the nonclustered index key?
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
June 13, 2011 at 1:10 pm
Maybe take a read through these articles...
http://www.sqlservercentral.com/articles/Indexing/68439/
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
June 13, 2011 at 1:15 pm
Thank you
Mike Scalise, PMP
https://www.michaelscalise.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply