SQL Server Performance Forum – Threads Archive
Update Statistics Vs DBCC REINDEXHi, I would like to schedule some maintenance tasks on my db server. I have confusion in this. What is the difference and purpose between update statistics and dbcc reindex? If i need to schedule both, which one i need to run first and on what frequency needs to be done. Thanks,
DBCC DBREINDEX must be scheduled first and only include those tables that are modified frequently here and not all ofthem if your system needs 24/7 availablity. In addition to this intermittent UPDATE STATISTICS execution will also help to retain the performance. You should leave the AUTO_UPDATE stats option ON the database is required most performance. The difference between them is to review BOL in addition to:
http://sqlserver-qa.net/blogs/tools…r-2005-index-optimization-best-practices.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks Satya. It’s really useful