Lesson 5 of 8
Accelerate with indexes and read EXPLAIN
Link an index to a real query and measure its cost.
42 minPostgreSQL Pro
By the end of this lesson
- Read a plan
- Choose the columns of an index
- Recognize a useless index
SQL Essentials
Unlock this lesson and continue the path.
Accelerate with indexes and read EXPLAIN is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge