Sign inSign in
ConceptSystems & CS

Projection pushdown

Eliminating redundant attributes early in the query plan before pipeline breakers to reduce materialization costs.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 3 definitions
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.

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 optimization technique that moves projection operations as low as possible in the query tree to reduce the number of columns processed.
    • 30:26Query Planning & Optimization
  • Andy Pavlo

    Carnegie Mellon University · Graduate

    • 17:59Query Optimizer Implementation 1

Lectures that assume it

1

Connections

9

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.