Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Index Tuning
Making Sure You're Ready for Class: Free Prerequisites
Concepts to Grasp First
Getting Your Computer Ready
Download the Scripts & Resources
1: Which Columns to Index
Which Columns Should You Index at First? (22:55)
Why You Shouldn't Start With Multi-Column Indexes (23:46)
Lab: Picking Columns to Index (4:32)
Watch Brent Do the Lab (31:10)
2: How Functional Indexes Help Timestamps and Varchars
Why Timestamp Columns Often Need Functional Indexes (15:26)
Lab: Designing Functional Indexes for Timestamp Columns (3:34)
Watch Brent Do the Lab (16:10)
3: Indexing for Sorts & Order By
Sorting Many Rows From One Table (24:28)
Sorting a Few Rows From One Table (10:54)
Lab: Designing Indexes for Order By (1:03)
Watch Brent Do the Lab (14:24)
4: How Partial Indexes Reduce Size and Overhead
Where Partial Indexes Make Sense (9:00)
Lab: Design Partial Indexes Where They Make Sense (1:19)
Watch Brent Do the Lab (7:37)
5. Your First Big Lab: The Single-Table-Query Lab
Installing pgbench on a Mac
Run the "Before" Load Test, Create Your Indexes, and Test Again
Watch Brent Do the Lab (Script done, video coming soon)
6: Indexing for Joins
Why IDs Make Good Starter Indexes
Teach online with
Where Partial Indexes Make Sense
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock