June 6, 2011 at 7:31 am
Hi,
I am new to SQL Server and self taught, so please excuse if this is a stupid question.
Hypothetically, assume a table with 20 fields, and 3 fields that are searched on extensively.
If I create an index (non-clustered) with one of those fields, then performance significantly increases.
But, is there a difference between:
a) Creating 3 seperate non-clustered indexes for each of my 3 fields as Index Key Columnns
or
b) Creating 1 index with the 3 Index Key Columns
Thanks in advance.
Matthew
June 6, 2011 at 7:56 am
Gail knows:
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
-- Gianluca Sartori
June 6, 2011 at 8:20 am
Gianluca Sartori (6/6/2011)
Gail knows:http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
Indeed she does..... thank you very much for the pointer.
June 6, 2011 at 8:26 am
Gianluca Sartori (6/6/2011)
Gail knows:http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
Thank you Gian for pointing to the right material.
M&M
June 6, 2011 at 8:29 am
If you're just getting started with indexes, maybe this will be a good read (3 parts in total) http://www.sqlservercentral.com/articles/Indexing/68439/
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply