Contents Index Recursive hash join Duplicate elimination

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms
      Join algorithms

Recursive left outer hash join

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.


Contents Index Recursive hash join Duplicate elimination