Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-15714

[Server]: Add time-series bounded collection scan plans to query multi-planner

    XMLWordPrintableJSON

Details

    Description

      Original Downstream Change Summary

      We now consider clustered index scan in multi planning if it can be used., so now it will compete with secondary indexes.
      In previous versions we only considered clustered index scan if there is no secondary indexes or an explicit hint was given: https://www.mongodb.com/docs/manual/core/clustered-collections/#limitations

      Description of Linked Ticket

      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

            lauren.tran@mongodb.com Lauren Tran
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1 year, 14 weeks ago