Optimization

Read a plan with EXPLAIN and improve the query.

In this challenge you will read a query plan with EXPLAIN and add an index.

EXPLAIN SELECT * FROM products WHERE price > 100;
-- Seq Scan → CREATE INDEX → Index Scan

Read plan, add index.

All columns are selected from products. WHERE keeps only the rows where price > 100 holds.

Exercise Optimization

See the plan with EXPLAIN SELECT * FROM products WHERE price > 100.

Show example solution

EXPLAIN SELECT * FROM products WHERE price > 100;

Add EXPLAIN

____ SELECT * FROM products WHERE price > 100;

Show answer

EXPLAIN SELECT * FROM products WHERE price > 100;