Sorting algorithms are applicable when the query includes an ORDER BY clause, or when the query's execution strategy requires a total sort of its input.

For more information, see Sort algorithm (Sort) and UnionAll algorithm (UA).