Query Folding
· 5 min read
Optimize your SQL Queries by Clicks!
Copyright © 2024 PawSQL
Definition
By enabling Query Folding rule, PawSQL merges view references, derived tables and common table expressions to outer query blocks to:
- avoid materializing intermediate result-set
- enable more join order planning
- enable more opportunities for index recommendation
We will use view in following paragraph, but all the descriptions also apply to derived tables and common table
expressions.