The Runtime Theory

topic / query-planning-and-execution

Query Planning and Execution

Follow declarative SQL into a tree of physical operators.

Understand parsing, rewrites, cardinality estimates, scan and join choices, executor nodes, plan inspection, and measurement caveats.

1 article · 1 video · 1 trace · 1 request flow · 1 interview · 5 total

Articles

query planning and executionSep 25, 2026

Reading a Query Plan as an Execution Hypothesis

A query planner estimates alternative ways to produce a result and chooses one using statistics and cost assumptions.

Request Flows

request flow · 5 stagesHow Reading a Query Plan as an Execution Hypothesis worksAn interactive concept flow for reading a query plan as an execution hypothesis, from its assumptions through the main operation and boundary checks.

Videos

query planning and executionSep 25, 2026

Video lesson: Reading a Query Plan as an Execution Hypothesis

Recording brief and narration plan for a visual lesson on reading a query plan as an execution hypothesis.

Traces

trace 01 · systemTrace: Reading a Query Plan as an Execution HypothesisFollow the key state changes and boundary checks involved in reading a query plan as an execution hypothesis.

Interviews

medium · t2Explain Reading a Query Plan as an Execution HypothesisExplain the model, execution steps, complexity, and limits of reading a query plan as an execution hypothesis.

Explore adjacent

New lessons by email

Get new explanations about query planning and execution and related systems in your inbox.

One technical dispatch per week. No noise.