ASA SQL User's Guide
Query Optimization and Execution
Query execution algorithms
Join algorithms
The recursive left outer hash join is a variant of the hash join algorithm used in certain recursive union queries.
For more information, see Hash join, and Recursive common table expressions.