Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Name the stages a SQL statement passes through before execution: parsing, logical plan, physical plan.
- Explain what a logical plan represents, as distinct from a physical plan.
- Explain where the optimizer fits into this pipeline, and what it chooses between.
- Connect this pipeline to the execution plan reading covered in Level 5.
Level 5 covered EXPLAIN as a way to see the chosen physical plan. This page opens up what happens before that plan is chosen. It covers the stages a plain text SQL statement passes through on its way to becoming something the database can actually execute.