[SERVER-67496] Heuristic CE for SARGable elemMatch FilterNode Created: 24/Jun/22 Updated: 01/May/23 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Timour Katchaounov | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | bonsai-ce | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Optimization
|
||||||||
| Sprint: | QO 2022-07-11, QO 2022-07-25, QO 2022-08-08, QO 2022-08-22, QO 2022-10-03 | ||||||||
| Participants: | |||||||||
| Description |
|
Implement heuristic-based CE for SARGable FilterNodes that represent an elemMatch. |
| Comments |
| Comment by Timour Katchaounov [ 12/Oct/22 ] |
|
In the light of latest dicussions, SERVER-67498 will not handle this case automatically. In addition, this ticket should add specific tests, including tests with negation - see TEST(CEHeuristicTest, CENotEquality). |
| Comment by Timour Katchaounov [ 01/Sep/22 ] |
|
This task is blocked on a task not yet filed in Jira that should implement a compact representation of conjunctions of elemMatch conditions as a single SargableNode. svilen.mihaylov@mongodb.com please let us know once you create a Jira (or decide not to). |