I have used different indexes for the same table to test query performance. I got two different results as the following:
1) scan count 1, logical reads 580
2) scan count 2, logical reads 523
I am wondering which one is better than the other, high scan count but low logical or low scan count, high logical? Can anyone give me some suggestions? specially, when the data set becomes really large, which one has long term benefit? Thanks...