Use subplanner for $or query over clustered collections in automaticCE mode

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Critical - P2
    • 8.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • Fully Compatible
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Plan enumeration for $or queries over clustered collections produces different plans when it is run over the $or branches vs. the whole query.

      A clustered index scan can be created and used for individual branches, but it may not be created over the whole query, in which case only collection scan is created. 

      In automaticCE plan ranker mode always use the subplanner if the collection is clustered.

            Assignee:
            Milena Ivanova
            Reporter:
            Milena Ivanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: