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
No practice set picked yet.
Suggest oneWhich roles ask for it
- 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.