karthik M (1/22/2013)
#1)Logical Read : 20
#2)
Logical Read:2
which one is better? Less Logical Read. But it uses "Table Scan". Again I think as the table record is very less, it is not the right time to take any decision ( i mean based on 18 records). right?
Well which would you prefer, more reads (more data read) or less?
But yes, can't do meaningful performance tests on 18 rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability