[SERVER-959] never do a table scan to answer db.f.find( {y:10} ).sort( {x:1} ) when have index {x:1,y:1} Created: 04/Apr/10 Updated: 10/Dec/14 Resolved: 04/Dec/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Aaron Staple | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 4 |
| Labels: | query_triage | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Participants: | |||||||||
| Description |
|
explain() output indicates a table scan may be attempted along with the index |
| Comments |
| Comment by Aaron Staple [ 04/Apr/10 ] |
|
same in simpler case with index {x:1} |