CSE Roadmap

Common tier · about 2 hours · 5 parts

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.