Execution strategy
Query Plan
Database Query Plan
Also known as · Execution Plan · SQL Plan · Query Execution Plan
Definition
The estimated cost and order of table scans, index access, joins, and sorting that a database chooses to execute a SQL statement.
Searchable examples
- Seq Scan
- Index Scan
- Index Only Scan
- Bitmap Index Scan
Short example
A sequential scan can be correct for a small table. Compare rows, buffers, sorting, and result size on representative data.