Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Top N Sort Showplan Operator

Top N Sort is similar to the Sort iterator, except that only the first N rows are needed, and not the entire result set. For small values of N, the SQL Server query execution engine attempts to perform the entire sort operation in memory. For large values of N, the query execution engine resorts to the more generic method of sorting to which N is not a parameter.

Community Additions

© 2016 Microsoft