Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Index Tuning
Before the Class
Prerequisites Before the Class
Introductions and Overview (4:21)
Download the Slide Decks and Demos
Designing Indexes for the WHERE Clause
How to Design Indexes for Equality and Inequality Searches (37:41)
Lab: Design Indexes for WHERE (16:24)
Lab: Brent's Solutions (46:54)
Designing Indexes for ORDER BY
How to Design Indexes for ORDER BY (19:12)
Lab: Design Indexes for WHERE + ORDER BY (0:46)
Lab: Brent's Solutions (25:50)
Designing Indexes for JOINs
How to Design Indexes for JOINs (26:23)
Lab: Design Indexes for JOINs (0:50)
Lab: Brent's Solutions (16:27)
How SQL Server Comes Up with Index Recommendations
Meet Clippy: How SQL Server Designs Its Own Indexes (16:57)
Bonus Lab: Get Clippy's Indexes from sp_BlitzIndex
Bonus Lab: Brent's Solutions (15:35)
Recap and Next Steps
Recap and Next Steps (6:10)
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