SQL Server Performance

Statistics

Discussion in 'T-SQL Performance Tuning for Developers' started by Eh, Feb 14, 2003.

  1. Eh New Member

    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.
  2. bradmcgehee New Member

    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
  3. satya Moderator

    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

Share This Page