[SERVER-86289] Omit unnecessary cfilter PlanStage in parameterized SBE index plans Created: 06/Feb/24 Updated: 07/Feb/24 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Ben Shteinfeld | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Optimization
|
| Participants: |
| Description |
|
In the MixedWorkloads genny workload (high-value workload), there are queries of the form
Note that the field id is not _id, but does have a secondary index.
This leads to a plan like
The constant filter stage above the ixseek does not appear to be necessary since we know that the bounds will be constants and parameterized in the query. This be obsoleted by SERVER-86237, but it might help with queries not covered by that ticket. |