[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:
Related
Assigned Teams:
Query Optimization
Participants:
Case:

 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.


Generated at Thu Feb 08 05:26:47 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.