Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Query Optimization and Execution » Query execution algorithms » Join algorithms

Nested Loops Semijoin algorithm Next Page

Recursive Hash Join algorithm

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 algorithm, and Recursive common table expressions.