Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
4.2.7
-
None
-
Query Optimization
Description
Allow for the simple creation of a wildcard index that indexes specific patterns below the wildcard:
db.collection.createIndex(
|
{ "FieldHolder.$**.SearchSort": 1 } |
)
|
To capture only the SearchSort fields in an example like this:
{
|
FieldHolder: {
|
Field1: {
|
Meta: { Some: "Metadata we dont want to index" }, |
More: { Metadata: "we don't want to index"}, |
Value: "Some Value", |
SearchSort: "some value" |
},
|
Field2: {
|
Meta: { Some: "Metadata we dont want to index" }, |
More: { Metadata: "we don't want to index"}, |
Value: 1, |
SearchSort: "1", |
},
|
Field3....
|
}
|
}
|
This would also more easily allow the implementation of non-sparse indexing on wildcards, where you could forcibly assume the existence of some field (SearchSort in this case)
Attachments
Issue Links
- related to
-
SERVER-44558 wildcardProjection not available for subtrees
-
- Backlog
-
-
SERVER-267 Wildcard support in index/query/projection
-
- Backlog
-