SQL Server Performance

_WA_ indexes

Discussion in 'Performance Tuning for DBAs' started by condiotti, Jun 1, 2006.

  1. condiotti New Member

    Does anyone have a query that can find the columns for all the _wa_ indexes in a database?

    Thanks
  2. ranjitjain New Member

    select so.name,si.name,sc.name from sysindexes si
    inner join sysobjects so on
    si.id=so.id
    inner join syscolumns sc on
    so.id=sc.id
    where si.name like '_wa%'
  3. satya Moderator

    SP(underscoe)HELPINDEX does too along with all other indexes [<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br />If you have AUTO_CREATE_STATISTICS set on for this database, so SQL server will automatically build these statistics indexes when columns are used as a predicate in a query. In my experience there is no harm in keeping these statistics indexes as they will certainly assist in less common query processing.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Share This Page