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 ...
© Jason Strate 2019
J. StrateExpert Performance Indexing in SQL Server 2019https://doi.org/10.1007/978-1-4842-5464-6_33. Index Metadata and Statistics
Jason Strate1
(1)
Hugo, MN, USA
Get Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
