Sort avoidance

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

Related concepts
Predicate transformations
Transitive closure
View transformations
Subquery processing and transformations
Outer join transformations
Aggregate processing