Details
-
Bug
-
Resolution: Won't Do
-
Major - P3
-
None
-
Ubuntu 14.04 on Virtualbox on Windows
*Location*: https://docs.mongodb.com/v3.0/core/query-optimization/
*User-Agent*: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
*Referrer*: https://docs.mongodb.com/manual/core/query-optimization/
*Screen Resolution*: 1920 x 1080
Ubuntu 14.04 on Virtualbox on Windows *Location*: https://docs.mongodb.com/v3.0/core/query-optimization/ *User-Agent*: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36 *Referrer*: https://docs.mongodb.com/manual/core/query-optimization/ *Screen Resolution*: 1920 x 1080
Description
Covered queries:
I have noticed that in v3.0 a "find" query with a $in condition uses index only ("totalDocsExamined: 0" in explain() result), while a count query with the same conditions does not. Is this an undocumented limitation or just different optimization results for these 2 kinds of queries?