Part 05 · Join Algorithms
Index Nested Loop Join
Index nested loopIndex lookupSelective joins
When the inner side has an index, each outer row becomes one lookup. Why this plan dominates OLTP joins like 'this user's last 10 orders'.
⏱ 6 min · Station 39 of 123
✎
This chapter is being written.
The route is mapped; the full walkthrough arrives here soon.