SQLBits 2015

Indexing Internals

In this session we'll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes.
In this session we'll dig into the internal structures of indexes.  We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes and how the SQL Server uses the data within the indexes to find rows quickly.