Double Pipelined Join (Tukwila)
Hash Join
- Partially pipelined: no output until inner read
- Asymmetric (inner vs. outer) — optimization requires source behavior knowledge
Double Pipelined Hash Join
- Outputs data immediately
- Symmetric — requires less source knowledge to optimize