cannot get covered query with $expr with $eq only

XMLWordPrintableJSON

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

      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:
              Milena Ivanova
              Reporter:
              Miguel Ángel Nieto
              Votes:
              5 Vote for this issue
              Watchers:
              25 Start watching this issue

                Created:
                Updated: