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 ...