Are these _WA indexes an indication for the developer to create an index on that column? Also will these _WA indexes affect performance? Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
If you search the fora, you'll find plenty of information about these statistics and hypothetical indexes. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>