Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Index Tuning 2026
Before the Class
Introductions (20:09)
Prerequisites
Change Log for This Class
Watch the Live Class
Download the Slides & Demos
Bending the 5 & 5 Guideline with Special Indexes
Filtered Indexes (37:41)
Indexed Views (39:56)
Computed Columns (28:45)
Automatic Indexing Through Time (22:36)
Lab 1 Assignment (7:20)
Lab 1: Brent Does It (37:10)
Heaps and Clustered Indexes
Where to Use Heaps and How to Pick Clustering Keys (48:20)
Fixing Blocking with Index Tuning
Fixing Blocking with Index Tuning (42:14)
Lab 2 Assignment (7:34)
Lab 2: Brent Does It (38:26)
Making Tough Decisions When You Scale
When to Remove Constraints and Foreign Keys (35:02)
Choosing Between Partitioned Tables and Views (43:42)
How to Get Seeks on the Second Column of an Index (15:04)
Lab 3 Assignment (5:47)
Lab 3: Brent Does It (47:00)
Specialized Index Types
Tuning Indexes to Avoid Key Lookups (20:12)
Indexing JSON (25:50)
Doing the D.E.A.T.H. Method
Deduping and Eliminating (44:56)
Lab 4 Assignment (5:28)
Lab 4: Brent Does It (52:57)
Where to Use Heaps and How to Pick Clustering Keys
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock