[SERVER-17128] Apply index filters to individual $or clauses for rooted $or queries Created: 30/Jan/15 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.7 |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Linda Qin | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| 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 |
|
Assume that I have a $or query as below:
And the index filters are configured for query1 and query2 separately. Currently the query engine doesn't use the index filters for these sub-queries in the $or clauses, but rather looks for an index filter set on the entire query shape. It would be nice if the $or clause shapes use the index filters for them individually, so that we can "hint" the indexes for each clause separately. |