-
Type: Improvement
-
Resolution: Duplicate
-
Priority: 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.
- is duplicated by
-
SERVER-75079 Simplify boolean expressions before feeding them to the optimizer
- Closed
- is related to
-
SERVER-60373 Duplicate predicates in query plan for time-series collection
- Closed
-
SERVER-81788 Optimize $elemMatch in the Boolean expression simplifier
- Backlog
-
SERVER-75079 Simplify boolean expressions before feeding them to the optimizer
- Closed
- related to
-
SERVER-31360 MatchExpression::getOptimizer() for $or/$and should collapse equivalent clauses
- Closed