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

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

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Trivial - P5 Trivial - P5
    • 6.2.0-rc0, 6.0.7
    • Affects Version/s: None
    • Component/s: 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

      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.

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