The following features are disabled by default:
- COUNT DISTINCT Performance Improvement
- In-Memory Outer Hash Join Optimization, a part of In-Memory Optimization Enhancements
- UNION ALL Optimizations