Back to search

What is an execution plan?

An execution plan shows how the database intends to run a query, including scans, joins, sorts, and index usage.

SQL Medium Theory

What is an execution plan?

An execution plan shows how the database intends to run a query, including scans, joins, sorts, and index usage.

  • Look for full scans
  • Check join strategy
  • Used to explain slow queries

What is an execution plan?