Query plan

Applies to: sql

A query plan is the database engine's chosen strategy for running a query: scans, joins, sorts, and index lookups.

EXPLAIN SELECT * FROM users WHERE email = 'a@b.com';

See also: index, join, big-o