[SERVER-6253] Covered index not working on sub documents Created: 29/Jun/12 Updated: 15/Aug/12 Resolved: 29/Jun/12 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 2.0.5 |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | René de Kat | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Description |
|
I have a problem with indexes on subdocuments where indexOnly is always false. Take this code for example from the Mongo Docs (altered a bit to resemble my problem): db.factories.insert( { name: "xyz", metro: { city: "New York", state: "NY" } } ); ); , {_id:0, "metro.city" : 1} ).explain(); } Notice the indexOnly is false although an index is used and only indexed values should be returned. Hence the {_id:0, "metro.city" : 1} part. } |
| Comments |
| Comment by Scott Hernandez (Inactive) [ 29/Jun/12 ] |
|
Dup of |