-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
QO 2024-04-29
-
(copied to CRM)
Right now, clustered collection scans can be bounded by a min value and max value. This works well for queries containing $eq, $lt/e, $gt/e, and $and. But, it's not sophisticated enough to most efficiently bound queries containing $in and $or. These queries would benefit from bounds that look more like a set of ranges.
- related to
-
SERVER-67105 $in queries do not use clustered index
- Closed