Expand description
Join operators: HashJoin, NestedLoopJoin, MergeJoin.
Structsยง
- Hash
Join Node - Hash join: builds a hash table from the build side, probes with the probe side.
- Merge
Join Node - Merge join: requires both inputs sorted on join keys.
- Nested
Loop Join Node - Nested loop join: for each outer row, scans all inner rows testing condition.