Does Index/Shard size affects the performance of search/create/update query? So suppose I have 2 indexes. In one index I have 2 GB data and in another index I have 10 GB data. If I fire same search/insert/update query on both the indexes then performance of both query will be same? Or the index which have 10 GB data will take more time that the index which have 2 GB data?
Longer answer, it depends, and if you want to have a definitive answer based on your usage pattern you should test.