ConceptSystems & CS
Block nested loop join
An optimized nested loop join algorithm that reads blocks or pages of the outer relation into memory rather than individual tuples to reduce disk accesses.
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
1Connections
4The lectures that define it or assume it, and the concepts next to it.