The Runtime Theory

SQL Becomes a Physical Query Plan

Follow SQL through parsing and planning into scans, joins, buffers, visibility checks, and result rows.

The Runtime Theory Team05 stages

trace / request.md

PARSE AND RESOLVECHOOSE A PLANREAD INPUTSRUN OPERATORSRETURN ROWS

readyThe database validates SQL syntax, resolves tables and columns, and builds an internal query representation.

Plan nodes and execution choices are database-specific. PostgreSQL's EXPLAIN output is a concrete way to inspect the plan tree.

Not started

Sign in to save your learning progress.

Sign in to save