Query Rewrite Summary
The optimizer can use any semantically correct rule to transform one query to another.
Rules try to:
- move constraints between blocks (because each will be optimized separately)
- Unnest blocks
Especially important in decision support applications where queries are very complex.