papapumpy (1/5/2010)
Yes, indexing helps but reducing logical reads does not help performance. maybe a tiny bitread some article about buffer hit ratio and data cache. physical reads is the one takes significantly longer time. i actually wrote my final term paper about that when i was in CS in my college long time ago.
Dr. Inner Join
The thread may be over a year old, but I have to add a correction as to not confuse new readers. Reducing logical reads does[/do] improve query performance! In fact, logical reads is one of the best metric to look at when optimizing a query. Logical reads represents the data that must be read from cache in order to process a query. The less amount of data needed to process a query, the better it performs.
Using SET STATISTICS IO ON when optimizing queries can help you quickly, by looking at the logical reads counter, determine where to focus your tuning efforts. Seeing the logical reads by object can quickly point you to poorly performing sections of your query.
So to recap, I think the statement that "reducing logical reads does not help performance. maybe a tiny bit" is not true.