- 
    Type:Improvement 
- 
    Resolution: Unresolved
- 
    Priority:Major - P3 
- 
    None
- 
    Affects Version/s: None
- 
    Component/s: None
- 
        Query Optimization
- 
        QO 2024-04-29
- 
        (copied to CRM)
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
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
 
-