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 ...