Details
-
Bug
-
Resolution: Duplicate
-
Major - P3
-
None
-
2.6.1
-
None
-
ALL
Description
mongodb (2.6.1) use index is order dependent.
in mongodb (2.4.10):
indexes: (a_1), (a_1, b_1)
db.test.find(
{a: 1, b: 1}).explain() -->
indexBounds: (a_1, b_1)
but in mongodb (2.6.1):
indexes: (a_1), (a_1, b_1)
db.test.find(
{a: 1, b: 1}).explain() -->
indexBounds: (a_1)
if I build index in reverse order:
indexes: (a_1, b_1), (a_1)
db.test.find(
{a: 1, b: 1}).explain() -->
indexBounds: (a_1, b_1)
Attachments
Issue Links
- duplicates
-
SERVER-14207 Use index is order dependent
-
- Closed
-