ConceptSystems & CS
Skip scan
A query optimization technique where an index is traversed using partial attributes of a composite key even when leading attributes are omitted.
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.
Lecturers
2Each in their own terms, from the easiest level.
D. Richard Hipp
An optimization technique where the query planner iterates through all possible values of the first column in a multi-column index when it has few distinct values, performing separate lookups for the second column.
Connections
4The lectures that define it or assume it, and the concepts next to it.