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

Remove projection for multiplanning in case of distinct command

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 8.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • Fully Compatible
    • QO 2024-09-02, QO 2024-09-16
    • 0

      Before multiplanning, the canonical queries eligible for DISTINCT_SCAN were treated separately, and a projection (generally, with the distinct key) is set by default. For the fallback find the projection was eliminated. Now, since we are multiplanning both IXSCANs and DISTINCT_SCANs are under the same canonical query, and we no longer need to add a projection.

            Assignee:
            alya.berciu@mongodb.com Alya Berciu
            Reporter:
            eduard.alexmihai@mongodb.com Eduard Alex Mihai (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: