SQL Server 2019 Administration Inside Out

Chapter 15Understanding and designing indexes

Designing clustered indexes

Designing rowstore nonclustered indexes

Understanding columnstore indexes

Understanding indexing in memory-optimized tables

Understanding index statistics

Understanding other types of indexes

In this chapter, we dive into indexing of all kinds—not just clustered and nonclustered indexes—including practical development techniques for designing indexes. We spend time on memory-optimized tables throughout, including hash indexes for extreme writes, and columnstore indexes for extreme reads. We review “missing” indexes and index usage, and then introduce statistics: how they are created and updated. There are important performance-related options for statistics objects. ...