UnionAll 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 such as HashDistinct or OrderedDistinct is needed to remove any duplicates generated by UnionAll.
See HashDistinct algorithm (DistH), and OrderedDistinct algorithm (DistO).
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |