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

Extend express plan executor to work with single field equality predicates on non-unique indexes

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Optimization

      Today the express path works with _id exact-match lookups and there is ongoing work to extend to exact-match lookups in unique indexes.

      We should further extend this path to work for exact-match lookups on non-unique indexes (which may often be "de facto unique"). This is more complicated than the unique index case, since it's possible that there will be multiple results. The PlanExecutor will have to support saving/restoring state.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: