[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.


Generated at Thu Feb 08 06:20:42 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.