SQL Server Performance Forum – Threads Archive

Update Statistics Vs DBCC REINDEX

Hi, 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,
Bala

---

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://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
http://sqlserver-qa.net/blogs/tools…r-2005-index-optimization-best-practices.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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

---

]]>