Non-cost-based optimizationsThe 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.