Index Metadata and Statistics

  • Jason Strate
  • Grant Fritchey

Abstract

Now that you understand the logical and physical fundamentals of indexes, you should 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 the 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 commands and dynamic management objects (DMOs) that are available and see how that information comes to be.

Keywords

Statistic Object Density Vector Execution Plan Query Optimizer 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.

Supplementary material

978-1-4842-1118-2_3_MOESM1_ESM.zip (27 kb)
Performance Indexing - Chapter 03 - Index Metadata and Statistics.zip (zip 28 kb)

Copyright information

© Jason Strate and Grant Fritchey 2015

Authors and Affiliations

  • Jason Strate
    • 1
  • Grant Fritchey
    • 1
  1. 1.MNUS

Personalised recommendations