[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:
Duplicate
is duplicated by SERVER-3310 Query optimizer should efficiently ha... Closed
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}
Generated at Thu Feb 08 02:55:39 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.