Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    71

    Unanswered: dbcc dbreindex/indexdefrag & Update Stats

    Microsoft states that dbcc DBREINDEX automatically updates statistics but INDEXDEFRAG does not. If this is the case, does MS mean that only the affected statistics are updated or all statistics? Also, is it a good idea to run 'Update Statistics' after doing INDEXDEFRAG?

    Clive

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    All statistics for that table are updated on DBREINDEX. I would run UPDATE STATISTICS anytime after running INDEXDEFRAG.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •