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)

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      None

      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.

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

              Created:
              Updated:
              Resolved: