How to maintain SQL Server indexes for query optimization - The Diigo Meta page

• 06 Apr 08
  

  Paulo Nogueira
  • Occasionally it's a good idea to run sp_updatestats or UPDATE STATISTICS.
  • Since re-indexing changes the statistics results, I recommend that after  re-indexing, you manually run sp_updatestats or the T-SQL UPDATE STATISTICS  command

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.