August 14, 2002 at 6:41 am
I noticed when I did a SP_help on some of my SQLServer 7.0 tables I see several
_WA_Sys_ indexes. I looked in BOL but can't seem to find any info on these indexes. Any one know what they are ?
August 14, 2002 at 10:44 am
They hold statistics on the columns.
Andy
August 15, 2002 at 1:27 am
Hi Andy,
Is there any administration that one should be performing on these or are they just to be ignored.
DeltaKilo
August 16, 2002 at 9:41 am
While they are not to be administered directly they are often a symptom of missing user-defined indexes. Depending how performance critical the table in question is, you might want to have another look at your indexes.
August 16, 2002 at 9:43 am
Ignore these. They are system generated.
Steve Jones
August 16, 2002 at 3:05 pm
I agree that they should be ignored, but I believe they are maintained by updating your statistics, whether you have set to happen automatically or do it via a job. Having bad stats will definitely lead to bad query plans.
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply