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
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
