[SERVER-78994] [CQF] Change fallback to allow eligible queries through CQF when there is a $natural hint Created: 14/Jul/23  Updated: 29/Oct/23  Resolved: 28/Jul/23

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

Type: Task Priority: Major - P3
Reporter: Hana Pearlman Assignee: Militsa Sotirova
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-07-24, QO 2023-08-07
Participants:

 Description   

Currently, queries against collections with secondary indexes (which are otherwise eligible) are not allowed through CQF. We should allow these queries to go through CQF when there is a $natural hint. We should also make use of any multikeyness info from the indexes to simplify the plan.



 Comments   
Comment by Githook User [ 28/Jul/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-78994 Change fallback to allow eligible queries through CQF with natural hint
Branch: master
https://github.com/mongodb/mongo/commit/5f1b3024bf6e1d2f79e0c934a694b92929370c16

Comment by Militsa Sotirova [ 24/Jul/23 ]

Extending the scope of this ticket to also allow queries with a predicate on _id to run through Bonsai if there is a $natural hint since that will force a collection scan over IDHACK (this is the classic behavior).

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