Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-92456 Multiplan DISTINCT_SCANs
  3. SERVER-92614

Support multiplanning DISTINCT_SCAN for distinct command

    • Type: Icon: Sub-task Sub-task
    • 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-08-05, QO 2024-08-19, QO 2024-09-02, QO 2024-09-16

      See comments for prototype code links. This ticket includes adding relevant (golden) tests for multiplanning distinct(), and making sure that when the feature flag is enabled:

      • We're still generating distinct scan plans as before, but now from all eligible indexes.
      • Multiplanning generates/picks alternate index scans when we have few/no duplicates; otherwise favoring distinct scan as before.
      • We update existing tests that may be broken by this behaviour when the feature flag is enabled.

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

              Created:
              Updated:
              Resolved: