[SERVER-27904] Extend support for moving predicates into contained ORs to multikey indexes Created: 03/Feb/17  Updated: 05/Apr/17  Resolved: 28/Feb/17

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 3.5.4

Type: Task Priority: Major - P3
Reporter: Tess Avitabile (Inactive) Assignee: Tess Avitabile (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-13732 Predicates in top-level implicit AND ... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query 2017-02-13, Query 2017-03-06
Participants:

 Description   

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.



 Comments   
Comment by Githook User [ 28/Feb/17 ]

Author:

{u'username': u'tessavitabile', u'name': u'Tess Avitabile', u'email': u'tess.avitabile@mongodb.com'}

Message: SERVER-27904 Extend support for moving predicates into contained ORs to multikey indexes
Branch: master
https://github.com/mongodb/mongo/commit/0501a56bfbb9a3b7d88a9b57e371de44afe02564

Generated at Thu Feb 08 04:16:34 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.