Data
Why a query is slow
Indexes, query plans and the common reasons a query that used to be fast isn't any more.
About 10 hours of study.
Where to learn it
Read
Use The Index, Luke
Markus Winand
Chapters 1–3
The book support and backend engineers wish they'd read sooner.
Section not checked yet
Watch
Database Systems (CMU 15-445/645)
Andy Pavlo
Lectures on indexes and query execution
Lecture videos are on the CMU Database Group YouTube channel.
Section not checked yet
Practise
PostgreSQL Exercises
Alisdair Owens
Every section, then rewrite your slowest answers after reading their EXPLAIN plans
Runs in the browser against a real database.
Section not checked yet
Wrong chapter, dead link, or know something better? Tell us on GitHub.
Which roles ask for it
- BI developer in the first year
- Analytics engineer good to have
- Database administrator to get hired
- Data scientist in the first year
- Application support engineer in the first year
Before and after
Why a query is slow
Opens up
Nothing else on the map yet.