Rewrite/Optimizations
The rewrite is also a very important phase and its output is also the execution plan.This phase is responsible for distributed relational query optimization and suitable native SQL generation. The phase of rewriting covers:
- Multi-database join plan generation
- Function shipping
- Functional compensation analysis
- Optimized SQL generation
Read more about this topic: Oracle BI Server