Posted on 2003-03-11
My company sells software products. One of the customers production DBAs has noticed that their prodn database has a lot of indexes in the sysindex table named '_WA%'
(select * from sysindexes where name like '_WA%')
I have been asked to investigate these indexes as the customer suggests that their presence indicates a lack of suitable 'real' indexes.
I have looked in BOL for details of _WA indexes and cant find anything.
Can any expert help me understand:-
1. What are these entries about?
2. How can I interpret the data?
3. Do they suggest that I am missing indexes or are they normal internal SQL server operations?
4. Any other useful info on these peculiar entries.
Thanks in advance