Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Index Tuning
Before the Class
Prerequisites
Introductions and Overview (16:39)
Download the Slide Decks
Change Log for This Class
The D.E.A.T.H. Method - Starting with the D.E.
Dedupe and Eliminate (41:55)
Why Index Read & Write Numbers are Wrong (23:08)
Lab 1 Setup: Do the D.E. Steps (4:30)
Lab 1: Brent's Solution (24:04)
The T Step: Tuning Indexes for Specific Queries
Tuning Indexes for Specific Queries (27:33)
Foreign Keys and Check Constraints (17:59)
Lab 2 Setup: Do the T Step (4:50)
Lab 2: Brent's Solution (90:26)
The A Step: Adding Indexes with Clippy and the DMVs
Adding Indexes with Clippy's Recommendations (39:55)
Avoiding Key Lookups and Residual Predicates (22:18)
Lab 3 Setup: Do the A Step (3:45)
Lab 3: Brent's Solution (69:30)
The H Step: Heaps Usually Need Clustered Indexes
Heaps vs Clustered Indexes (32:27)
Tuning Indexes to Avoid Blocking
Blocking: When the 5 & 5 Guideline Isn't Specific Enough (31:28)
Lab 4 Setup: Reducing Blocking with Just Index Changes (2:58)
Lab 4: Brent's Solution (132:28)
Artisanal, Hand-Crafted, Specialized Index Types
Filtered Indexes, Indexed Views, and Computed Columns (43:22)
Indexing for JSON Queries (16:44)
Using an Index's Second Column with Skip Scans (16:03)
Lab 5 Setup: Leverage Artisanal Indexes (4:04)
Lab 5: Brent's Solution (34:49)
Recap and Final Lab
Lab 6 Setup and Class Recap (11:36)
Lab 6: Brent Does the D.E.A. (36:47)
Lab 6: Brent Does the D.E.A.T. (30:39)
Bonus: Tips from the Index Sommelier (20:49)
Using an Index's Second Column with Skip Scans
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock