Penalize ixisect during plan scoring so that it won't get chosen over faster single-index plans

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 2.6.0-rc1
    • Affects Version/s: 2.5.5
    • Component/s: Querying
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      We have seen cases where the multi plan runner cannot distinguish between index intersection and single index plans. For instance, if the query has zero results, then all plans could be equally unproductive, and we have no information to distinguish between the various plans (see SERVER-12639). The ixisect plan might be chosen even if it is dramatically slower than the other plans.

      We should penalize ixisect plans and require them to make up the delta with a no-fetch bonus.

            Assignee:
            David Storch
            Reporter:
            David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: