Home Forums SQL Server 7,2000 T-SQL How to Reduce the Logical Reads, to imporve the Performance of the Query RE: How to Reduce the Logical Reads, to imporve the Performance of the Query

  • Yes, indexing helps but reducing logical reads does not help performance. maybe a tiny bit

    read 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