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)

Other Resources

UNION (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance