LyraLearn AI Learning Platform
Exams
← SQL Server Performance Tuning
Module 3

Index Design That Actually Helps

Clustered vs nonclustered, covering indexes, and the missing-index DMVs — used carefully.

3.1
"Clustered vs Nonclustered"
10 min
3.2
"Composite Key Order and INCLUDE"
13 min
3.3
"Covering Indexes and Killing Lookups"
11 min
3.4
"Why Missing-Index Recommendations Mislead"
12 min
3.5
"Filtered Indexes for Reporting"
10 min
3.6
"Statistics, Fragmentation, and the Cost of Writes"
12 min