SQL Server Performance

Indexes

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
    _WA_Sys_EntryDate_1B0907CE
    _WA_Sys_TicketId_1B0907CE
    _WA_Sys_UserID_1B0907CE

    Why are these indexes created???

    Thanks
    Venu
  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
    Webmaster
    SQL-Server-Performance.Com
  3. satya Moderator

    Nothing to worry, just ignore them.

    Satya SKJ

Share This Page