Query system table sysindexes using
select name,indid,rows from sysindexes where name like '_WA%'
displays lots rows. These are not created by users, does not look like indexes as they have now rows.
In SQL 2005 Management Studio, these _WA objects are listed for some tables under Statistics.
What are they and what are they for?
Thanks
Gang