O'Reilly logo

Expert Performance Indexing in SQL Server, Second Edition by Grant Fritchey, Jason Strate

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 7

image

Indexing Memory-Optimized Tables

The past few chapters have focused on indexing related to specialized indexing capabilities in SQL Server. The common thread through those indexes is their reliance on disk-based storage as the primary medium for storing the data and providing data access. SQL Server 2014 introduces a new manner in which a table can be made available,called a memory-optimized table.

Memory-optimized tables are significantly different from traditional tables, with memory being the primary medium for the tables. In this chapter, you’ll look at how the changes for memory-optimized tables affect your ability to index these ...

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