-
Type:
Improvement
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
Labels: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
-
-
-
- Backlog
-
-
-
- Closed
-
- related to
-
-
- Closed
-