Sign inSign in
ConceptSystems & CS

Top-down optimization

A query optimization strategy that starts with the desired result and works down the tree to find the optimal plan.
as Jignesh Patel defines itCarnegie Mellon UniversityThe wording closest to all 5 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.

Query optimization3Branch-and-bound search1Cascades framework1Logical query plan1Physical operators1Query optimization tree1Query plan1Transformations1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Graduate

    An optimization strategy where the planner starts with the desired outcome and traverses down the tree using transformations to find the optimal plan.
    • 2:41Query Optimizer Implementation 2
    • 54:48Snowflake Data Warehouse Internals
    • 1:00:39Query Optimizer Implementation 1
    • 40:41SQL Optimization Background

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.