Plans
The Query Processor might actually execute this as 2 selects, a join, a select and a project.
- A smarter optimizer might do additional projects.
- Seem intuitive? It's really intuitive only for the smallest queries.
Execution plan or strategy is a plan for getting the result of a query.
- Includes not only the order, but what implementation (sorting, hashing, etc.) to use