SQL Server 2022 Administration Inside Out

Chapter 15

Understand and design indexes

• Design clustered indexes

• Design rowstore nonclustered indexes

• Understand columnstore indexes

• Understand indexes in memory-optimized tables

• Understand index statistics

• Understand other types of indexes

This chapter dives into indexing of all kinds—not just clustered and nonclustered indexes—including practical development techniques for designing indexes. It mentions memory-optimized tables throughout, including hash indexes for extreme writes and columnstore indexes for extreme reads. The chapter reviews missing indexes and index usage, and then introduces statistics—how they are created and updated. There are important performance-related options for statistics objects. Finally, it explains special ...