The following changes help improve the accuracy of optimizer costing and provide additional paths for query execution:
Transitive closure can be applied to joins
Predicate factoring and transformation can improve costing for queries using or
Special like optimization for leading wildcards in strings
These features are described in Chapter 5, “Understanding the Query Optimizer,” in the Performance and Tuning Guide.
