August 1, 2003 at 2:55 pm
Hello...
My system is telling me that I have Indexes on certain Tables - the problem is I've never created them.
If I go into the MMC Snap-In for SQL Server and change the data View to "TaskPad" - I see many Indexes on Tables which are prefixed with _WA_Sys_ and I have no explanation.
Here is a sample Index for column TaxableYes:
_WA_Sys_TaxableYes_51300E55
These things only show up in the Taskpad view and some tables have several of them per table.
What are these things and how do I get rid of them ????
Thanks - B
August 1, 2003 at 3:08 pm
I ran into the same situation few months back... These Index are created by the SQL Setver itself to optimise the query performance based on the usage.
This feature started from SQL Server 7.0 version.
You could see my earlier posting here as well as replies...
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11272
.
August 5, 2003 at 12:19 am
If iam not mistaken you are talking about the auto statistics. This will be created by the SQL Server for every objects in the Database if the "Auto create statistics" option is ON. You can set it OFF from the enterprise manager or using the system procedures.
You can find the advantages and disadvantages of statsitics from BOL.
Regards,
Chels.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply