[SERVER-36521] Prevent allPaths indexes from generating self-intersecting plans Created: 08/Aug/18  Updated: 29/Oct/23  Resolved: 11/Sep/18

Status: Closed
Project: Core Server
Component/s: Index Maintenance, Querying
Affects Version/s: None
Fix Version/s: 4.1.3

Type: Task Priority: Major - P3
Reporter: Bernard Gorman Assignee: Bernard Gorman
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-53927 Support AND_SORTED plans using wildca... Backlog
Backwards Compatibility: Fully Compatible
Sprint: Query 2018-08-27, Query 2018-09-10, Query 2018-09-24
Participants:

 Description   

Because allPaths indexes are effectively a collection of single-field indexes on each field of the document, the planner generates a number of AND_SORTED plans for queries involving two or more of the indexed fields. While this is consistent with the planner's behaviour in the case where each individual field was indexed separately, we should consider banning the planner from generating these plans for an allPaths index.



 Comments   
Comment by Githook User [ 11/Sep/18 ]

Author:

{'name': 'Bernard Gorman', 'email': 'bernard.gorman@gmail.com', 'username': 'gormanb'}

Message: SERVER-36521 Prevent allPaths indexes from participating in index intersection
Branch: master
https://github.com/mongodb/mongo/commit/a08202469ed08f507f2d6cbb8e45158e4cf10839

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