Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WA_SYS_

Status
Not open for further replies.
jjlbmcnews

jjlbmcnews

IS-IT--Management
Oct 4, 2001
60
GB
If you had a lot of tables in your database that had indexes that started WA_SYS_ would this mean that the index design is not up to scratch? I understand these WA_SYS_ indexes to be indexes that have been created by the system because of a lack of correct indexes, does this sound about right?
 
Sort by date Sort by votes
Those are not actually indexes - they are statistics. SQL Server creates these automatically by default and having them on columns does not necessarily mean you need an index on that column.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top