The business problem
An email search slows down as the table grows.
What you will be able to do
Compare a plan before and after an index, and explain the index's cost.
- Read EXPLAIN
- Create a suitable index
- Recognise a useless index
- Measure before optimising
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- SELECT, filters and joins
Project and practice
The planned structure contains 9 exercises and a mini-project. They will remain unavailable until they have been run and validated.