I have a compound key with field
Cardinality of fields is
articleIdhas 20000 different value
- host has 17 value
- timestamp is increasing field with time
I want to use
articleId_1_host_1_timeStamp_1 as shard key.
Could you please suggest if I can use this as shard key with timestamp field in it? Also do I need to create a different index using these three fields or can I use the above compound key with shard key of of first three fields?