Flow Distinct Showplan Operator

The Flow Distinct logical operator scans the input, removing duplicates. Whereas the Distinct operator consumes all input before producing any output, the FlowDistinct operator returns each row as it is obtained from the input (unless that row is a duplicate, in which case it is discarded).

Flow Distinct is a logical operator.

See Also


How to: Display an Actual Execution Plan


Distinct Showplan Operator


Eliminating Duplicates with DISTINCT
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance