• Thank you guys!

    I can understand that we should keep Scan Count and Logical Reads as low as possible. But When you come to the point where you have to choose between high Scan Count and low Logical Reads and Low Scan Count and High Logical Reads,which one we should go with and which one gives long term benefits?

    As for Antares686 reply, I am a little confused here, usually we want to keep logical reads as low as possible to increase performance, but you mentioned here, we should want them as high as possible? Can you please tell me why so?