Sign inSign in
ConceptSystems & CS

Index nested loop join

A join algorithm that uses an index on the inner relation's join key to avoid sequential scans when searching for matches for each outer tuple.
as Matt Butrovich defines itCarnegie Mellon University
Watch it explained

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.

Indexes1Naïve nested loop join1Nested loop join1

Lecturers

1

    Connections

    2

    The lectures that define it or assume it, and the concepts next to it.

    Concept1

    Lecture1

    1 lecturer. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.