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 » Query expression algorithms

RowReplicate algorithm Next Page

Union All algorithm

The Union All algorithm reads rows from each of its inputs and outputs them, regardless of duplicates. This algorithm is used to implement UNION and UNION ALL clauses. In the UNION case, a Duplicate Elimination algorithm is needed to remove any duplicates generated by the Union All.