Sort Avoidance

Sorting is an expensive process. Derby tries to eliminate unnecessary sorting steps where possible.

• DISTINCT Elimination Based on a Uniqueness Condition
• Combining ORDER BY and DISTINCT
• Combining ORDER BY and UNION