How Index Keys & Includes Work (1 hour)

Build your powers of index design by learning how indexes are structured in SQL Server

Why can you seek on key columns?

Where are included columns written, and how can you use them?

In this demo-based course, we’ll use undocumented commands in SQL Server to explore the secrets of a disk-based rowstore index.

Course scripts are located at https://github.com/LitKnd/SQLWorkbooks/tree/main/how_index_keys_and_includes_work

Each video offers captions in English, and a written transcript is in each lesson.

Modules

Menu