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

Add time-series bounded collection scan plans to query multi-planner

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Trivial - P5 Trivial - P5
    • 6.2.0-rc0, 6.0.7
    • None
    • None
    • Fully Compatible
    • v6.0
    • QO 2021-09-20, QO 2021-10-04, QE 2022-10-17, QE 2022-10-31, QE 2022-11-14
    • 35

    Description

      After SERVER-54398, queries on time-series collections will only consider a bounded collection scan when no indexed solution is available. However there are cases where the bounded collection scan results in better performance than an indexed plan, for example when the indexed solution has wide index bounds and must fetch many documents. We should add the bounded collection scan as a potential plan and compare it with indexed solutions in the query multi-planning process.

      Attachments

        Activity

          People

            ivan.fefer@mongodb.com Ivan Fefer
            katherine.wu@mongodb.com Katherine Wu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: