Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-36521

Prevent allPaths indexes from generating self-intersecting plans

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 4.1.3
    • Affects Version/s: None
    • Component/s: Index Maintenance, Querying
    • None
    • Fully Compatible
    • Query 2018-08-27, Query 2018-09-10, Query 2018-09-24
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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.

            Assignee:
            bernard.gorman@mongodb.com Bernard Gorman
            Reporter:
            bernard.gorman@mongodb.com Bernard Gorman
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: