O'Reilly logo

Practical Maintenance Plans in SQL Server: Automation for the DBA by Bradley Beard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_10

10. Updating Object Statistics

Bradley Beard

(1)Palm Bay, Florida, USA

Don’t worry; this book isn’t really about math. I’m not going to trick you into doing any statistics homework or anything. When SQL Server refers to statistics, what does that mean?

Statistics, in this reference, means distribution statistics.

Great… so what does that mean? If you remember back in Chapters 7 and 8, we talked about indexes. Remember how we said that, for the B-Tree structure, there were different levels and how each level fed the next higher level? Distribution statistics is what defines those levels.

Distribution Statistics Explained

Let’s say that you have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required