-
Type: Improvement
-
Resolution: Won't Do
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Storage Execution
For example, using an existing index on {a:1, b:1}, support creating a new index on {b:1} or {b:1} with partialFilterExpression on 'a'.
From SERVER-36202:
This might be an improvement. We would still need to sort the keys for 'b'. We wouldn't need to scan the collection to generate keys, but we would need scan the index to generate new keys. This improvement would have to come from avoiding key generation from BSON to KeyString, which is very highly optimized. We would have to show that key generation from an existing KeyString(a,b) -> KeyString(b) is significantly faster than BSON -> KeyString.
In addition, this should also have a smaller memory footprint by avoiding the need to page in full documents.
- related to
-
SERVER-36202 when creating new index, use existing index if possible to avoid collection scan
- Backlog