DBSophic

Posts tagged "maintenance"

Index rebuilds and statistics updates

 Posted by Ami Levin on Wednesday, 25 April 2012

An interesting discussion came up lately on the MVP private forums regarding index rebuilds,recompilation and statistics updates. Although the debate spanned too many aspects for me to cover here in this short post, I think that one important point should be emphasized as it might be making you do redundant work or even worse - unknowingly degrade the performance of your workload.

Continue reading