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 utilize 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jason Strate
About this chapter
Cite this chapter
Strate, J. (2019). Index Metadata and Statistics. In: Expert Performance Indexing in SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5464-6_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5464-6_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5463-9
Online ISBN: 978-1-4842-5464-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)