If i have a huge database and i want to improve performance , either i can
- Increase number of shards
- Partition a single index logically (say one index will hold a year's
data) and restrict the search to the required index only. I agree we get
some mileage here as we are restricting the search to the required index
Is there any other advantages for multiple index over multiple shards here ?