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

speculatively evaluate multiple query plans for each $or clause (even after 101 matches found for query)

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Duplicate
    • None
    • None
    • Querying
    • None

    Description

      For non $or queries, the query optimizer attempts to speculatively evaluate a query using multiple indexes in parallel, until 101 matches are found with a single index.

      For $or queries, each $or clause can potentially speculatively evaluate multiple indexes. However, after 101 total matches are found speculative evaluation is stopped and an index is chosen arbitrarily for each $or clause.

      This ticket represents allowing speculative index evaluation in $or clauses even after the first 101 matches are found.

      Attachments

        Issue Links

          Activity

            People

              david.storch@mongodb.com David Storch
              aaron Aaron Staple
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: