Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-64994

Extend the planner to allow soft hints about index traversal direction for predicate satisfaction

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.0.0-rc10, 6.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • v6.0, v5.0
    • QO 2022-04-18, QO 2022-05-02, QO 2022-05-16, QO 2022-05-30, QO 2022-06-13

      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.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            samuel.mercier@mongodb.com Sam Mercier
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: