[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: |
| 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). |