Autoplay
Autocomplete
Previous Lesson
Complete and Continue
How to Think Like the Engine
Before the Class
Prerequisites Before the Class
Download the Demo Pages PDF
The Video Lectures
Part 1: Clustered Indexes and the WHERE Clause (25:38)
Part 2: ORDER BY and Caching (15:44)
Part 3: Nonclustered Indexes, Seeks vs Scans (15:46)
Part 4: Key Lookups, the Tipping Point, and Cost-Based Optimization (21:39)
Part 5: Bad Queries and Wider Indexes (20:51)
Part 6: Recap and Next Steps (5:56)
The Written Lectures
Prefer Reading Instead of Videos?
Big Data Edition
Download the Script
Part 1: PAGEIOLATCH Waits (21:31)
Part 2: Nonclustered Indexes and Key Lookups (10:25)
Part 3: Sorts, Writes, and Memory Grants (16:03)
Download the Demo Pages PDF
Download
01 How to Think Like the Engine - Demo Pages.pdf
Complete and Continue