Distinct Showplan Operator

The Distinct operator removes duplicates from a rowset or from a collection of values.

Distinct is a logical operator.

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Eliminating Duplicates with DISTINCT

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)