Change Log for This Class | Brent Ozar Unlimited

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)

Change Log for This Class

September 4 - the first recordings are live for the 2026 rotation.

Complete and continue

Lecture Content Locked

Your session expired. Please sign in again to continue.

Login