Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-8779

$all now choose optimal condition not the first one

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.4.0
    • Component/s: Server
    • Labels:
      None
    • # Replies:
      3
    • Last comment by Customer:
      true
    • Story Points:
      0.5
    • Sprint:
      KANBAN BUCKET

      Description

      https://docs.mongodb.com/manual/reference/operator/query/all/#performance

      Queries that use the $all operator must scan all the documents that match the first element in the $all expression. As a result, even with an index to support the query, the operation may be long running, particularly when the first element in the $all expression is not very selective.

      With SERVER-16042 fixed I think it's not the case anymore

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              steve.renaker Steve Renaker
              Reporter:
              yaoxing.zhang Yaoxing Zhang
              Participants:
              Last commenter:
              Jonathan Dahl
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since reply:
                3 years, 35 weeks, 5 days ago
                Date of 1st Reply: