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

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • 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
            Reporter:
            Aaron Staple (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: