Major - P3 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
-