[SERVER-31100] Since 2.6, full collection scan instead of index scan, on range after sort Created: 15/Sep/17 Updated: 09/Oct/17 Resolved: 15/Sep/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Querying |
| Affects Version/s: | 2.6.12, 3.0.15, 3.2.16, 3.4.9, 3.5.13 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Clement R | Assignee: | Kelsey Schubert |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | compound_index, index, sorting | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Steps To Reproduce: | Steps :
Results :
More details :
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description |
|
Hello, index {a:1,b:1,c:1} Before 2.6 : all matching docs are found from index (probably by doing an index scan of part "c" ?) |
| Comments |
| Comment by Clement R [ 18/Sep/17 ] | |||||
|
Thanks for your reply. If I modify my query from :
explain() is good again in 2.6+ :
Kind regards, | |||||
| Comment by Kelsey Schubert [ 15/Sep/17 ] | |||||
|
Thank you for the detailed bug report. The work to resolve this issue is tracked in SERVER-13197. Please feel free to vote for SERVER-13197 and watch it for updates For additional details, please refer to Dave's comment on Kind regards, |