Indexing

Hi,
Could someone please tell me the "best" way to index a table? Is the best
way (defined as quickest access to data) to create an index on every field
individually that might be queried, or is it best to create an index that
contains multiple fields if that's how they appear after the WHERE clause.
Thanks,
SteveHi Steve
Check out
http://www.sql-server-performance.com/mr_indexing.asp
http://www.sql-server-performance.c...ance_audit7.asp
http://www.sql-server-performance.c..._structures.asp
What the article doesn't specify is that it is always worth running the
index tuning wizard just to see what it comes up with, in case you may have
missed something or alternatively as a starting point. I would use this for
analysis and implement the suggestions you believe to be suitable rather tha
n
implement them verbatim.
John
"Steve Caliendo" wrote:

> Hi,
> Could someone please tell me the "best" way to index a table? Is the best
> way (defined as quickest access to data) to create an index on every field
> individually that might be queried, or is it best to create an index that
> contains multiple fields if that's how they appear after the WHERE clause.
> Thanks,
> Steve
>
>