-
Type: Improvement
-
Resolution: Won't Do
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Sharding
-
None
-
Sharding EMEA
-
Sharding 2019-08-26
Currently is not possible to use as shard key a prefix of a multikey index.
For this reason, even if we have as shard key {a:1} and we have already the index {a:1, b:1} that is considered multikey ONLY because the field b is an array, we must have an index on {a:1} or a non multikey index where a is a prefix.
Allowing to use {a:1, b:1} for sharding will allow to save RAM, space and write overhead.
- is related to
-
SERVER-20857 dataSize command requires shard key, which fails on collections where shard key is prefix of a compound multikey index
- Closed