The default value for this is NULL, which means do not update statistics. If you have used Ola Hallengren’s scripts for maintenance, you hopefully know that it will also update statistics using the parameter. I’ve written about that here, so I won’t re-hash it. The sp_updatestats command isn’t a favorite of mine either.

But in a database with multiple 10 million row tables, it is a big deal. For a small database, or system that’s not 24×7, that isn’t such a big deal. I could have a 10 million row table where only 1000 rows change, and yet the statistics for that table will update. I don’t like this option because it means that statistics that have had little or no change will be updated. You can also specify whether it is a full scan or a sample for the update, but that’s about it: Update Statistics Task (Maintenance Plan) Within the maintenance plan options, the Update Statistics Task only provides the option to update Index statistics, Column statistics, or both. In fact, if you don’t know if you have a step or job that updates out of statistics on a regular basis, go check now! This post will still be here when you get back 😊Īt any rate, for a long time the default options for updating statistics were pretty much a sledgehammer. I am a HUGE fan of updating statistics as part of regular maintenance.

Update statistics sql server