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