ConceptSystems & CS
Predicate pushdown
Moving predicates down to the lowest possible point in the query plan, below join operators, to filter out data early.
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 algebra2Conjunctive predicates1Query optimization1Query plan1Query tree1Relational operators1Split conjunctive predicates1
Opens up
Concepts that name this one as a prerequisite.
Lecturers
2Each in their own terms, from the easiest level.
Jignesh Patel
A rule-based optimization technique that moves selection operations lower in the query tree to reduce the amount of data processed by subsequent operations.Andy Pavlo
Lectures that assume it
1Connections
10The lectures that define it or assume it, and the concepts next to it.