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.