Contents Index Recursive union Miscellaneous

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms
      Sorting and unions

Sort Top N

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.


Contents Index Recursive union Miscellaneous