Sign inSign in
ConceptSystems & CS

Physical plan

A plan defining the specific execution strategy and algorithms used to execute operators, depending on the data's physical format.
as Andy Pavlo defines itCarnegie Mellon University
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Logical plan2Access paths1Relational algebra1Storage layout1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Jignesh Patel

    Carnegie Mellon University · Undergraduate

    An annotated relational algebra tree that includes specific execution details like access paths and algorithms, which can be directly executed by the query engine.
    • 21:11Query Planning & Optimization

Lectures that assume it

4

Connections

12

The lectures that define it or assume it, and the concepts next to it.

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.