Summary - Optimization

Improve a slow query with EXPLAIN.

EXPLAIN shows the plan, indexes speed up, sargable uses indexes, JOIN solves N+1.

EXPLAIN SELECT * FROM products WHERE price > 100;

Summary optimization query.

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

Exercise Summary - Optimization

Summary: EXPLAIN SELECT * FROM products WHERE price > 100.

Show example solution

EXPLAIN SELECT * FROM products WHERE price > 100;