> 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).
each stats collection takes up at least a row sysindexes so they do consume storage, although it is
more than likely minimal.
> > 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
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
since you apparently have auto create stats on for this db, you probably want auto update stats on