[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:
Depends
depends on SERVER-69023 [CQF] Convert PathArr to Interval Closed
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).

Generated at Thu Feb 08 06:08:17 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.