Execution Plans

Difficulty: Intermediate

Question

What is an Execution Plan?

Answer

A report generated by the database engine showing how it intends to execute a query (order of joins, indexes used, etc.). Use `EXPLAIN ANALYZE` in SQL to see it.

Concepts covered

Explain, Query Tuning