ASA SQL User's Guide
Query Optimization and Execution
Query execution algorithms
Sorting and unions
The recursive union algorithm is employed during the execution of recursive union queries.
For more information, see Recursive common table expressions.