What should I choose between low logical read and faster execution time
Thank you in advance for reading my quesion.
I am tuning one suboptimal sql and have rewritten the sql in different ways,say them A,B and so on.
A has lower logical reads but longer execution time 7s.
B has higher logical reads but shorter execution time,3~4s.
A and B returns the same result set.
Our department usually buffer_gets/rows_returned to judge one sql good or not.
In this case, should I choose A or B?
And another doubt.
Let's assume that the criterion is buffer_gets/rows_returned <M
With parameter X, SQL retuns 100rows with about N logical reads. N/100<M