United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2000

Microsoft SQL Server 2000

SQL Server 2000 Books Online

Optimizing Database Performance

Query Tuning

Analyzing a Query

Logical and Physical Operators

Assert

Aggregate

Bookmark Lookup

Clustered Index Delete

Clustered Index Insert

Clustered Index Update

Clustered Index Scan

Clustered Index Seek

Collapse

Concatenation

Constant Scan

Cross Join

Delete

Deleted Scan

Distinct

Distinct Sort

Distribute Streams

Eager Spool

Filter

Flow Distinct

Full Outer Join

Hash Match

Hash Match Root

Hash Match Team

Index Delete

Index Insert

Index Scan

Index Seek

Index Spool

Index Update

Inner Join

Insert

Inserted Scan

Lazy Spool

Left Anti Semi Join

Left Outer Join

Log Row Scan

Merge Join

Nested Loops

Parallelism

Parameter Table Scan

Remote Delete

Remote Insert

Remote Query

Remote Scan

Remote Update

Repartition Streams

Right Anti Semi Join

Right Outer Join

Right Semi Join

Row Count Spool

Sequence

Sort

Split

Stream Aggregate

Table Delete

Table Insert

Table Scan

Table Spool

Table Update

Top

Union

Update

Cursor Logical and Physical Operators

Minimize

This topic has not yet been rated - Rate this topic

Flow Distinct

SQL Server 2000

Flow Distinct

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

See Also

Eliminating Duplicates with DISTINCT

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.