ConceptSystems & CS
Query optimizer
A component of a database system that transforms a logical query plan into a more efficient physical execution plan using rules or cost estimation.
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.
Relational algebra3Cost estimation1Cost-based optimization1Query execution1Query execution plans1Query optimization1SQL queries1Transformation rules1
Opens up
Concepts that name this one as a prerequisite.
Lecturers
2Each in their own terms, from the easiest level.
Andy Pavlo
The component of a DBMS that finds a correct physical execution plan for a given query with the lowest cost.
Lectures that assume it
8Connections
19The lectures that define it or assume it, and the concepts next to it.
Concepts7
- Relational algebra
- Cost estimation
- Accumulated-cost bounding
- Adaptive query optimization
- Cardinality estimation
- Cost model