Hi, I wanted to know whether it is feasible to query on all the shards even if the query yields data only from a few shards n not all. Or is it better to mention those shards explicitly from which we get the data and only query on them.
for example : I have 4 shards. Now I have a query which yields data only from 2 shards. So shoud I select those 2 shards only and query on them or it is ok to query on all the shards? Will that affect the performance in any way? Thanks Ankita