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

Improve plan ranking for index intersection

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: 2.6.0
    • Fix Version/s: Backlog
    • Component/s: Querying
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                6 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated: