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

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.0.0-rc10, 6.1.0-rc0
    • None
    • None
    • 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

    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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: