tony28 (10/30/2013)
SO my point is WHAT IS BETTER FROM ANOTHER POINT OF VIEW, I PREFER LONG TIME ( because i think this is still short time ) THAN LOT OF LOGICAL READS, what do you think ?
Logical reads means data is being read from buffer .. longer time means data (which is not available in buffer) is being read from disk. So what do you want ..every time physical reads (means data from disk ) ? why ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)