Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Index Tuning
Before the Class
Prerequisites Before the Class
Introductions and Overview (5:59)
Download the Slide Decks and Demos
Designing Indexes for the WHERE Clause
How to Design Indexes for Equality and Inequality Searches (34:21)
Lab: Design Indexes for WHERE (10:52)
Lab: Brent's Solutions (47:56)
Designing Indexes for ORDER BY
How to Design Indexes for ORDER BY (24:33)
Lab: Design Indexes for WHERE + ORDER BY (1:14)
Lab: Brent's Solutions (22:50)
Designing Indexes for JOINs
How to Design Indexes for JOINs (30:43)
Lab: Design Indexes for JOINs (1:37)
Lab: Brent's Solutions (25:11)
How SQL Server Comes Up with Index Recommendations
Meet Clippy: How SQL Server Designs Its Own Indexes (18:10)
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:51)
Download the Slide Decks and Demos
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock