ConceptSystems & CS
System R optimizer
A pioneering cost-based, bottom-up query optimizer that serves as the foundation for most modern database optimizers.
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.
Cost-based optimization1Dynamic programming1Generative / bottom-up approach1Join algorithms1Join ordering1Query optimization1
Lecturers
2Each in their own terms, from the easiest level.
Andy Pavlo
A bottom-up optimizer that breaks queries into blocks, generates logical and physical operators, and constructs a left-deep join tree minimizing estimated work.
Connections
4The lectures that define it or assume it, and the concepts next to it.