ASA SQL User's Guide
Query Optimization and Execution
Query execution algorithms
Sorting and unions
The Sort Top N algorithm is used for queries that contain a TOP N clause and an ORDER BY clause. It is an efficient algorithm for sorting only those rows required in the result set.
For more information, see SELECT statement.