undefined indexes _WA_Sys_<column>_???? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

undefined indexes _WA_Sys_<column>_????

when I do a select out of sysindexes, I get some indexes I <br />have never defined, they all named something like:<br /><br />_WA_Sys_&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />artial column name&gt;_&lt;some alpha numeric&gt;<br /><br />why so?
These are statistic indexes created automatically by sql server for columns where no real indexes exist (when the "auto create statistics" option is checked on the database). They are often a hint that you should look into applying some real indexes on these columns (but not always).
http://www.microsoft.com/sql/techinfo/tips/administration/autoindexes.asp for additional information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>