Details
-
Bug
-
Resolution: Duplicate
-
Major - P3
-
None
-
2.6.12, 3.0.15, 3.2.16, 3.4.9, 3.5.13
-
ALL
-
Description
Hello,
index {a:1,b:1,c:1}
find( {c:{$lt:100}} ).sort( {a:1,b:1} )
Before 2.6 : all matching docs are found from index (probably by doing an index scan of part "c" ?)
From 2.6 and above : index return docs in sorted order, but a full document scan is required to check "c".
Attachments
Issue Links
- duplicates
-
SERVER-13197 Tighten index bounds and allow compound index to be chosen when predicate on leading field is not provided
-
- Backlog
-