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
Run the "Before" Load Test, Create Your Indexes, and Test Again
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock