SQL Server Performance


Discussion in 'Performance Tuning for DBAs' started by avmreddy17, Dec 6, 2002.

  1. avmreddy17 New Member

    When I Do a sp_helpindex on a Table on SQLServer 2k , I See these index names created on the table
    Are these indexes created by the system ..because I have not created these indexes

    Why are these indexes created???

  2. bradmcgehee New Member

    These are normal. What you are seeing are not conventional indexes, but column statistics automatically created by SQL Server on columns frequently accessed by queries. This information is used by the Query Optimizer to provide it better information in order to make better decisions about the most optimal execution plan to run for a query.

    Brad M. McGehee
  3. satya Moderator

    Nothing to worry, just ignore them.

    Satya SKJ

Share This Page