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

eliminate redundant conditions/clauses from query

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Querying
    • None
    • Query Optimization

    Description

      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.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-60373 Duplicate predicates in query plan for time-series collection

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. SERVER-75079 Simplify boolean expressions before feeding them to the optimizer

          • Major - P3 - Major loss of function.
          • Open
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-31360 MatchExpression::getOptimizer() for $or/$and should collapse equivalent clauses

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Backlog

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              asya.kamsky@mongodb.com Asya Kamsky
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated: