question

Paras avatar image
Paras asked

'Update Statistics' task

In Maintenance Plan Wizard, one can select the task 'Update Statistics'. I have a question about this task.
If for a database, Auto Update Statistic is enabled then do I need to perform 'Update Statistics' manually in my maintenance plan?

statisticsmaintenance
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered

There has to be a certain number of updates to an index before its statistics get automatically refreshed. This may or may not be a problem, depending on how often data is updated and what queries you are using. Check out Kimberly Tripp's blog for details: http://www.sqlskills.com/BLOGS/KIMBERLY/category/Statistics.aspx

If you rebuild your indexes that takes care of the statistics as well. In fact, I believe that the Update Statistics task is harmful if run after the Rebuild Indexes task because it actually does a less thorough sampling.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.