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

Support AND_SORTED plans using wildcard indexes

XMLWordPrintableJSON

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • Query Optimization
    • Query Optimization 2021-03-08
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Ideally wildcard indexes should be usable anywhere an infinite number of {a:1}, {b:1}, etc indexes would be. But right now a query like {a:1, b:1} will use AND_SORTED of two IX_SCANs, but it won't try to use the equivalent plan if you have a wildcard index

            Assignee:
            Unassigned Unassigned
            Reporter:
            mathias@mongodb.com Mathias Stearn
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: