SORT
Short Description
The SORT operator represents the sorting of rows
Detailed Description​
The SORT operator represents the sorting of rows, optionally removing duplicates. Sorting is required where there is no supporting index that can be used. This is usually the last step before joining or grouping is performed.
If the sort cannot fit within the sort help size (sortheap) or pipelined, a temporary table will be used and performance will suffer. Ensure your predicates return only the rows necessary to reduce the sorting requirement.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.