O'Reilly logo

SQL Server 2012 Query Performance Tuning, Third Edition by Grant Fritchey

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

Chapter 7

image

Statistics Analysis

By now, you should have a good understanding of the importance of indexes. It is even more important for the optimizer to have the necessary information on the data distribution so that it can choose indexes effectively. In SQL Server, this information is maintained in the form of statistics on the index key.

In this chapter, you’ll learn the importance of statistics in query optimization. Specifically, I will cover the following topics:

  • The role of statistics in query optimization
  • The importance of statistics on columns with indexes
  • The importance of statistics on nonindexed columns used in join and filter criteria ...

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