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?
CliveAll statistics for that table are updated on DBREINDEX. I would run UPDATE STATISTICS anytime after running INDEXDEFRAG.
Showing posts with label automatically. Show all posts
Showing posts with label automatically. Show all posts
Thursday, March 8, 2012
Subscribe to:
Posts (Atom)