June 21, 2008 at 6:14 am
Hi everyone,
I would like to know which index is best for query performance?
With regards,
Sunil
June 21, 2008 at 6:47 am
a covering index - Index contains all data returned by the query thus preventing the need for look ups.
Gethyn Elliswww.gethynellis.com
June 21, 2008 at 9:58 am
It depends.
clustered index better for range scans, nonclustered better for specific rows, covering always good.
June 21, 2008 at 9:59 am
Depends on the data, depends on the table structure, depends on the query.
It's not a question that can be answered in isolation.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply