Sorting is an expensive process. tries to eliminate unnecessary sorting steps where possible. Sort avoidance Internal transformation of statementsSort avoidance