Let those statistics be with you!
There are a lot of questions about statistics that I receive in my trainings, projects and during my sessions: Why I have to rebuild statistics, if my auto-update stats option in ON. Why I still have bad plans or high CPU usage? Should I disable it or use full scan instead?
We usually rely on auto-update stats database options and sometimes perform a regular stats updates additionally in order to be sure that the QP has an up to date info about our table data. But there are some specific cases when those thinks just don’t help and even recompiling don’t boost the performance of a query. Let me list and explain for you some statistics updates exceptions cases and you will understand how to proper manage your statistics in order to gain max from them.
No material found.