[SERVER-6191] Index on key anywhere in the document Created: 24/Jun/12 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Index Maintenance |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Lean Berw | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | index | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Optimization
|
| Participants: |
| Description |
|
It would be great to have an index feature, so that when I am looking for an "address" it not only looks for it in the main field of the document, but also in the fields of the subdocuments. So it is an index on "address" AND "*.address". This way I can search for "phoneNumber" (e.g. using "*phoneNumber" as the search field name) and MongoDB has an index with all occurrences including "phoneNumber", "leader.phoneNUmber", "guests[].phoneNumber". |
| Comments |
| Comment by Andy Schwerin [ 24/Jun/12 ] |
|
Interesting idea. |