Details
-
Improvement
-
Resolution: Duplicate
-
Minor - P4
-
None
-
1.6.4
-
None
-
I`m not sure it not similar like http://jira.mongodb.org/browse/SERVER-1205
Description
Query
I have index on
db.ogloszenia2.ensureIndex(
);
db.ogloszenia2.find({"id":397).limit(200).sort({"x":-1); //use index
db.ogloszenia2.find({"id":422).limit(200).sort({"x":-1); //use index
db.ogloszenia2.find({"id":{$in:[397,422]}).limit(200); //use index
db.ogloszenia2.find({"id":{$in:[397,422]}).limit(200).sort({"x":-1); //does not use index
Attachments
Issue Links
- duplicates
-
SERVER-3310 Query optimizer should efficiently handle $in and sort with compound index.
-
- Closed
-