ConceptSystems & CS
ORDER BY ... LIMIT pushdown
An optimization technique where ordering and limit constraints are pushed down from the aggregator to the leaves and further into table scans as top filters.
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 optimization1SQL queries1
Lecturers
1Connections
2The lectures that define it or assume it, and the concepts next to it.