DB2 10.5 for Linux, UNIX, and Windows

UNION operator

This operator represents the concatenation of steams of rows from multiple tables.

Operator name: UNION

Represents: This operator represents a necessary operation. To improve access plan costs, concentrate on other operators (such as scans and joins) that define the set of rows to be concatenated.