Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Index Tuning
Before the Class
Prerequisites Before the Class
Introductions and Overview (5:13)
Download the Slide Decks and Demos
Designing Indexes for the WHERE Clause
How to Design Indexes for Equality and Inequality Searches (31:42)
Lab: Design Indexes for WHERE (8:38)
Lab: Brent's Solutions (53:55)
Designing Indexes for ORDER BY
How to Design Indexes for ORDER BY (22:55)
Lab: Design Indexes for WHERE + ORDER BY (1:37)
Lab: Brent's Solutions (22:50)
Designing Indexes for JOINs
How to Design Indexes for JOINs (34:32)
Lab: Design Indexes for JOINs (1:42)
Lab: Brent's Solutions (22:28)
How SQL Server Comes Up with Index Recommendations
Meet Clippy: How SQL Server Designs Its Own Indexes (32:53)
Bonus Lab: Get Clippy's Indexes from sp_BlitzIndex
Bonus Lab: Brent's Solutions (15:35)
Recap and Next Steps
Recap and Next Steps (7:05)
How to Design Indexes for ORDER BY
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock