-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
3
-
TBD
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Similar to SERVER-41252 doing work not to fetch when we have `$expr` and `$eq`, we should not need to FETCH when we have GT/LT which generated tight bounds (of the same type). So if the query was `$expr` with field greater than a date and less than a date and we are using a non-multikey index, we do NOT need to FETCH since we will know from the index use with tight bounds that there is nothing left to `filter` during FETCH.
Related to SERVER-69680
- is related to
-
SERVER-69680 allow $expr with comparison bounded by value and $type to use a non-multikey index
-
- Backlog
-
-
SERVER-41252 Enable covered query for $expr with $eq only
-
- In Code Review
-