Hello all, Say I have a table with one index (PK) on it. And I run sp_helpindex, if I see many entries that are statistics ( __WA_Sys_blabla )does this mean that perhpas I should think about putting some kind of index on these columns? All opinions are more than welcome. Thanks.
Not necessarily. A better way to evaluate whether or not you need an index on this table is to use Query Analyzer and run several of the most common queries that are run against this table, and then evaluate the execution plan to see if table scans are common. Or, you might consider using the Index Wizard. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com
As Brad referred, I also suggest for long running queries PROFILER is the best tool to capture and submit to the INDEX TUNING WIZARD for better recommendation on the indexes. HTH Satya SKJ
