Home Forums SQL Server 2005 Administering Best Index Rebuild/Reorganize and Update Statistics Strategy RE: Best Index Rebuild/Reorganize and Update Statistics Strategy

  • Thank you. Thanks for the query to find out heavily used indexes. Using this, as far as statistics are concerened, we won't be able to capture _WA statistics but only the indexed based statistics. So, should we update all the statistics on the table? This would be very time consuming. Any idea how to pull the heavily used WA statistics?