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

Understanding how indexes work will help you create effective indexes for your queries with less guess-work. This course teaches you:

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