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.
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
2Each in their own terms, from the easiest level.
Andy Pavlo
An optimization strategy where the planner starts with the desired outcome and traverses down the tree using transformations to find the optimal plan.
Connections
9The lectures that define it or assume it, and the concepts next to it.