Loading...

XML

Word

Printable

JSON

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

is related to

SERVER-60373 Duplicate predicates in query plan for time-series collection

SERVER-75079 Simplify boolean expressions before feeding them to the optimizer

SERVER-81788 Optimize $elemMatch in the Boolean expression simplifier

related to

SERVER-81788 Optimize $elemMatch in the Boolean expression simplifier

SERVER-31360 MatchExpression::getOptimizer() for $or/$and should collapse equivalent clauses

(1 related to)

Assignee:: [DO NOT USE] Backlog - Query Optimization
Reporter:: Asya Kamsky
Participants:: [DO NOT USE] Backlog - Query Optimization, Asya Kamsky, NOVALUE Mitar
Votes:: 1 Vote for this issue
Watchers:: 9 Start watching this issue