[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:
Backports
Depends
depends on SERVER-64349 Add heuristic-based planning support ... Closed
Related
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:

 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: SERVER-64994 Extend the planner to allow soft hints about index traversal direction

(cherry picked from commit 00d2a56763b2b0da941a41684d20e7080da5058e)
Branch: v6.0
https://github.com/mongodb/mongo/commit/0c75db7b1167d4544254724735535505bb6b4a70

Comment by Githook User [ 10/Jun/22 ]

Author:

{'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}

Message: SERVER-64994 Extend the planner to allow soft hints about index traversal direction
Branch: master
https://github.com/mongodb/mongo/commit/00d2a56763b2b0da941a41684d20e7080da5058e

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.

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