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

eliminate redundant conditions/clauses from query

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

      When query format is something like

      db.foo.find( {$and: [ { "a" : 1 }, { "a" : 1 } ] });
      
      db.foo.find({ "a": {"id":1}, "a":{$elemMatch:{"id":1, "b":9} } });
      

      In both cases one of the query parts is 100% redundant of the rest. This is to track optimizing it out of query consideration/evaluation.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            asya.kamsky@mongodb.com Asya Kamsky
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: