Non-Cost-Based Optimizations

The optimizer makes some non-cost-based optimizations, which means that it does not consider them when determining the access path and join order. If all the conditions are right, it makes the optimizations after the access path and join order are determined.

• Non-Cost-Based Sort Avoidance (Tuple Filtering)
• The MIN() and MAX() Optimizations