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

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

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 2.6.0-rc1
    • Affects Version/s: 2.5.5
    • Component/s: Querying
    • 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@mongodb.com David Storch
            Reporter:
            david.storch@mongodb.com David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: