Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Sort Showplan Operator
Collapse the table of content
Expand the table of content

Sort Showplan Operator

The Sort operator sorts all incoming rows. The Argument column contains either a DISTINCT ORDER BY:() predicate if duplicates are removed by this operation, or an ORDER BY:() predicate with a comma-separated list of the columns being sorted. The columns are prefixed with the value ASC if the columns are sorted in ascending order, or the value DESC if the columns are sorted in descending order.

Sort is a logical and physical operator.

Sort operator icon Graphical execution plan icon

Community Additions

ADD
Show:
© 2015 Microsoft