-
Type: Bug
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: 2.6.12, 3.0.15, 3.2.16, 3.4.9, 3.5.13
-
Component/s: Index Maintenance, Querying
-
ALL
-
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".
- duplicates
-
SERVER-13197 Tighten index bounds and allow compound index to be chosen when predicate on leading field is not provided
- Backlog