O'Reilly logo

SQL Server 2017 Administration Inside Out, First Edition by Randolph West, William Assaf, Sven Aelterman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10Understanding and designing 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 special types of indexes for niche uses. Finally, we explain statistics, how they are created and updated, and important performance-related options ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required