May 2023
Intermediate to advanced
992 pages
31h 14m
English
book
SQL Server 2022 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson
Content preview from SQL Server 2022 Administration Inside Out
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 15
Understand and design 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 ...