Union Showplan Operator
The Union operator scans multiple inputs, outputting each row scanned and removing duplicates.
Union is a logical operator.
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)