Top N Sort
Short Description
The Top N Sort operator is like the Sort operator but only returns the top n or top n percent rows
Detailed Description​
The Top N Sort operator is like the Sort operator but only returns the top n or top n percent rows. For a small number of rows, SQL Server will attempt to perform this sort completely in memory.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
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.