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.