[SERVER-72061] [CQF] Allow shared variables between IndexScan intervals Created: 13/Dec/22 Updated: 03/Jan/23 Resolved: 03/Jan/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Matt Boros | Assignee: | Backlog - Query Optimization |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Optimization
|
| Participants: |
| Description |
|
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. |