Details
-
Improvement
-
Status: Backlog
-
Major - P3
-
Resolution: Unresolved
-
None
-
None
-
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
-
SERVER-60373 Duplicate predicates in query plan for time-series collection
-
- Closed
-
-
SERVER-75079 Simplify boolean expressions before feeding them to the optimizer
-
- Open
-
- related to
-
SERVER-31360 MatchExpression::getOptimizer() for $or/$and should collapse equivalent clauses
-
- Backlog
-