I have some sybase queries to be tuned. I need to compare the performances of queries as I change them. I used "Set statistics io on" and "Set statistics time on" and I am getting the scancount, logical reads etc. I believe the idea is to reduce the scancounts and logical reads.
My questions is should we focus more on scan count or logical reads?
For example if
Query A yields Scancounts=20 Logical reads = 40
Query B yields Scancounts=40 Logical reads = 20