About the optimizer's choice of sort avoidanceSome SQL statements require that data be ordered, including those
with ORDER BY, GROUP BY, and DISTINCT. MIN() and MAX() aggregates also require
ordering of data.Sort avoidance
can sometimes avoid
sorting steps for:
Statements with ORDER BY
See .
can also perform the
following optimizations, but they are not based on cost: