Expand description
Physical relational join operators.
Structsยง
- Hash
Join - Nested
Loop Join - Nested-loop implementation for arbitrary join predicates and every SQL outer-join shape. Predicate evaluation happens against the merged row, so qualified columns and engine-provided scalar/subquery semantics remain available through the shared expression evaluator.