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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Query Optimizer » Query optimization and execution » Query execution algorithms » Join algorithms

 

RecursiveLeftOuterHashJoin algorithm (JHRO)

RecursiveLeftOuterHashJoin is a variant of HashJoin, and is used for certain recursive union queries. For more information, see HashJoin algorithms (JH, JHSP, JHFO, JHAP, JHO, JHPO), and Recursive common table expressions.