[SERVER-69025] [CQF] Performance-only partial schema requirements Created: 21/Aug/22  Updated: 29/Oct/23  Resolved: 22/Sep/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.2.0-rc0

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Svilen Mihaylov (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-68596 [CQF] A SargableNode should be genera... Closed
is depended on by SERVER-69024 [CQF] Handling of traverse with more ... Closed
Related
is related to SERVER-64007 Makes plans produced by Cascades opti... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2022-09-05, QO 2022-09-19, QO 2022-10-03
Participants:

 Description   

Allow a partial schema requirement to be marked as perf-only/optional. It will only be incorporated as part of index bounds, and never a residual predicate.

This will allow us to express extra predicates to satisfy yielding/transactional semantics: if we have a predicate which does not bind going on the left, it goes on the right as well, and the left side is marked as optional. It will also allow to model nested elemMatch, and array bounds (if we have an array constant as bound, we create a new bound using the first array element).



 Comments   
Comment by Githook User [ 22/Sep/22 ]

Author:

{'name': 'Svilen Mihaylov', 'email': 'svilen.mihaylov@mongodb.com', 'username': 'smihaylov-mongodb'}

Message: SERVER-69025 [CQF] Performance-only partial schema requirements
Branch: master
https://github.com/mongodb/mongo/commit/03714079f41a7d41a466316fd8486ee0215d2bc9

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