Sorting algorithms are applicable when the query includes an order by clause, and union algorithms are applicable for union queries.
For more information, see and .