Down the index rabbit-hole

So far in this chapter we have looked at the introduction of features and functionalities that were available in disk-based objects to the In-Memory OLTP engine. The improvements in indexing and the ability to alter your indexing strategy with memory-optimized tables without dropping it are particularly attractive. With that in mind, we will now spend some time investigating how the indexes are treated inside the storage engine. This will include a journey through the system catalogs and Dynamic Management Views (DMVs) to allow us to see how index information can be queried.

We will now take this opportunity to explore what the alteration of a bucket count can have on the data in our demonstration table.

Let's begin ...

Get SQL Server 2017 Developer's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.