SQL Server Performance

"DBCC DBReindex" VS "Update Statistics"

Discussion in 'General DBA Questions' started by KimChi, Feb 1, 2004.

  1. KimChi New Member

    Hi all,

    Is it neccessay to run the "Update Statistics" after run "DBCC DBReindex"? Does "Update Statistics" automatically update the stats?

    Thanks in advance
    Kim

    kim
  2. Luis Martin Moderator

    No it's no necessary.
    The idea is run DBReindex ones a week and Update Statistics more frequenly.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

Share This Page