Available now
Why is this query slow?
Two queries can return the same answer, one in a second and the other in an hour. The difference is the plan: the steps the database decides to take.
The database in your browser can show its plan and time your queries, so you see the difference instead of reading about it.
Why data engineers need it
- Cloud warehouses charge for every second and every byte scanned.
- Knowing why a query is slow beats guessing at fixes.
- Row versus column storage changes what "fast" means.
What you will learn
- What a query plan is, in plain words
- Reading EXPLAIN output from the bottom up
- Why column storage and filter pushdown make analytics fast
- EXPLAIN ANALYZE: real rows and time for every step
- Finding the join that multiplies rows, and measuring the fix
The lessons
Nothing to install. Nothing to break.
Every lesson runs in your browser, on your laptop or your phone.