-
Type: Improvement
-
Resolution: Won't Fix
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Query Optimization
Because of our interval simplification techniques, there can be a lot of shared information between index scan intervals. Here is the general equation we use for simplifying unioned intervals. We repeat a,b,c,d multiple times between the four bounds. This can result in large plans, for example here
We would like to factor out these repeated definitions into a "Let", so each index scan can share the definition.