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

cannot get covered query with $expr with $eq only

    • Query Optimization
    • QO 2024-02-05, QO 2024-02-19, QO 2024-03-04, QO 2024-03-18

      Hello,

      When using $expr, a query that should be covered by the index actually examine documents.

      Not only that, it searches for the values twice, once during the index scan and a second time during the fetch stage.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            miguel.nieto@mongodb.com Miguel Angel Nieto
            Votes:
            1 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated: