Very Computer

Hi,

I have a few tables, on which I create and drop indexes quite regularly.
I've noticed that every so often indexes appear which I have not created.
They are named like :-

    _WA_Sys_FileID_55FFB06A
    _WA_Sys_PhoneID_590D414E

I can't drop them, so I'm wondering what they are? and how I can, if
possible, avoid them?

Thanks for any help!
Colin

Colin

This is statistics that the optimizer collects as it feels necessary. Don't worry about it, as
it is good for you (and they don't consume storage). If you really want to drop them, check out
DROP STATISTICS.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

each stats collection takes up at least a row sysindexes so they do consume storage, although it is
more than likely minimal.

Quote:> > I have a few tables, on which I create and drop indexes quite regularly.
> > I've noticed that every so often indexes appear which I have not created.
> > They are named like :-

> >     _WA_Sys_FileID_55FFB06A
> >     _WA_Sys_PhoneID_590D414E

> > I can't drop them, so I'm wondering what they are? and how I can, if
> > possible, avoid them?

to avoid them, turn off  the auto create stats option.  to get rid of them use drop statistics like
tibor said.  the ss2k query analyzer has a manage statistics function where you can easily delete
them.
to put them to good use, see which autostats you have and determine whether or not the columns
referenced in the stats collection would be better with an index on them instead of simply a stats
collection.

since you apparently have auto create stats on for this db, you probably want auto update stats on
as well.

charlie