[SERVER-51901] Have the planner consider partial indexes for optimized contained-$or queries Created: 30/Oct/20 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Eric Sedor | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Assigned Teams: |
Query Optimization
|
||||
| Participants: | |||||
| Case: | (copied to CRM) | ||||
| Description |
|
The logic to strip invalid assignments of predicates to partial indexes is unaware of the contained-$or pushdown optimization. The analysis of which tags need to be stripped due to the partial index filter happens before any code relating to the contained-$or pushdown optimization. In order to fix this, we need to somehow make the index selection logic for partial indexes aware of the contained-$or pushdown optimization. |