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

Improve plan ranking for index intersection

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.6.0
    • Component/s: Querying
    • Query Optimization

      We know from performance testing that index intersection plans are faster than single-solution plans when

      1. The size of the intersection is small.
      2. The amount of data that would need to be fetched by the single-index solutions is large, so that
      3. this data would exceed the available memory, or is generally not in the working set.

      However, our testing also shows that index intersection plans may not be chosen by the ranker in these cases. We should consider tweaking plan ranking such that the ranker is more likely to choose intersection plans.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            david.storch@mongodb.com David Storch
            Votes:
            11 Vote for this issue
            Watchers:
            33 Start watching this issue

              Created:
              Updated: