Advertisement

Index Statistics

  • Jason Strate
  • Ted Krueger

Abstract

Now that you understand the logical and physical fundamentals of indexes, you should also look at the way in which statistics are stored for indexes. These statistics provide insight into how SQL Server can and is utilizing indexes. It also provides information needed to decipher why an index may not be selected and how it is behaving. This chapter will provide you with a deeper understanding about where and how this information is collected. You’ll investigate some additional DBCC statements and Dynamic Management Objects (DMO) that are available and demonstrate how that information comes to be.

Keywords

Index Statistic Execution Plan Query Optimizer Leaf Level Query Plan 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jason Strate and Ted Krueger 2012

Authors and Affiliations

  • Jason Strate
  • Ted Krueger

There are no affiliations available

Personalised recommendations