[SERVER-64994] Extend the planner to allow soft hints about index traversal direction for predicate satisfaction Created: 28/Mar/22 Updated: 29/Oct/23 Resolved: 13/Jun/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc10, 6.1.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Sam Mercier | Assignee: | Matt Boros |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||
| Backport Requested: |
v6.0, v5.0
|
||||||||||||||||
| Sprint: | QO 2022-04-18, QO 2022-05-02, QO 2022-05-16, QO 2022-05-30, QO 2022-06-13 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||
| Description |
|
Our planning strategy for BUS involves choosing to perform the rewrite only if the planner selects a compatible index. But because the query planner can only choose the index based off match predicates (we don't push down any sort information past the unpack buckets stage). But, the planner always chooses a forward (collection, index) scan to satisfy match predicates. This "soft" hint will tell the planner if you're trying to match a predicate on say (meta, time) it would be nice if the scan happened in this particular order as opposed to the default order. This is intended as an internal-only feature of the planner. |
| Comments |
| Comment by Githook User [ 13/Jun/22 ] |
|
Author: {'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: (cherry picked from commit 00d2a56763b2b0da941a41684d20e7080da5058e) |
| Comment by Githook User [ 10/Jun/22 ] |
|
Author: {'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: |
| Comment by Sam Mercier [ 01/Apr/22 ] |
|
david.storch i wrote a description. let me know if there's anything i can do to further clarify. |
| Comment by David Storch [ 31/Mar/22 ] |
|
samuel.mercier can you provide a description for this ticket? I'm curious to know more about this. |