SERVER-13732 entails moving a predicate into a contained OR to tighten index bounds, i.e. if we have indexes {b: 1, a: 1} and {c: 1, a: 1}, the query
db.coll.find({$and: [{a: 2}, {$or: [{b: 3}, {c: 4}]}]})
should have the plan
OR ( IXSCAN {b:[[3, 3]],a:[[2, 2]]} IXSCAN {c:[[4, 4]],a:[[2, 2]]} )
This ticket requires the above plan to be generated even if the index is multikey.
- is related to
-
SERVER-13732 Predicates in top-level implicit AND query not considered when generating index access plan for contained OR
- Closed