Part 05 · Join Algorithms

Block Nested Loop Join

Same idea, smarter I/O: load a block of outer rows into memory and scan the inner table once per block instead of once per row.

⏱ 6 min · Station 38 of 123