- 
    Type:Bug 
- 
    Resolution: Done
- 
    Priority:Major - P3 
- 
    None
- 
    Affects Version/s: 2.6.5
- 
    Component/s: Querying
- 
    None
- 
        ALL
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
when same query and index run on 2.6.4 it is much faster then on 2.6.5 , looking at explain show second scan to not use the indexes.
the attached js file has both query and explain results for both versions, can see millis difference . 150015 on 2.6.5 compared to 0 on 2.6.4 server.
follow is [ObjectId()]
query use $in and $nin .
the affect is noticed when users is more then 110000 documents on a server with 1GB RAM.
- related to
- 
                    SERVER-14618 Wrong index bounds when using "hint" -         
- Closed
 
-         
- 
                    SERVER-15279 Disable hash-based index intersection (AND_HASH) by default -         
- Closed
 
-