-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
Query Optimization
-
QO 2024-02-05, QO 2024-02-19, QO 2024-03-04, QO 2024-03-18
-
(copied to CRM)
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.
- is duplicated by
-
SERVER-83529 Generate covered projections with $expr
- Closed
-
SERVER-96826 $expr with find() does not use an index
- Closed
- is related to
-
SERVER-96826 $expr with find() does not use an index
- Closed