Optimiseintermediate
35 min
Optimise a Slow Query
You're given a query that joins Orders, Customers, and OrderItems and runs in 4 seconds on a 500k-row dataset. Use `EXPLAIN` / execution plan to identify the bottleneck, add the right indexes, and verify the improvement. Do not change the query itself.
Your progress0%
Requirements
Skills you'll use
SQLIndexesQuery OptimisationExecution Plans
Read this first
This task is based on the lesson below. Complete the reading before attempting it.
Go to lessonWhat to expect
- Difficulty
- intermediate
- Time
- 35 min
- Steps
- 6
- Type
- Optimise