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

Recursive hash join

The recursive hash join is a variant of the hash join algorithm that is used in recursive union queries.

For more information, see Hash join, and Recursive common table expressions.