So this post is a continuation of sorts of my last post on Updating Statistics before or after an index rebuild. I asked myself the question “How often should you run statistic maintenance in general? and do I have to run any statistic maintenance if I have auto update stats enabled?” OK I didn’t REALLY [...]
Posts Tagged ‘sp_updatestats’
Update Statistics Before or After an Index Rebuild?
So a Twitter friend of mine @peschkaj tweeted this morning: “Just finished adding scripts to update stats and rebuild indexes after our nightly and weekly loads. Now on to… something else.” So I asked the question: “now the question is… did you update stats BEFORE or AFTER the index rebuild? ” He replied with the [...]
