tony28 (10/30/2013)
GilaMonster (10/30/2013)
Don't look at scan count. It is not the number of times a table has been scanned, it's not consistently the number of times a table has been accessed either.it means that for example
If I have SCAN 1 and logical reads 100
and scan 2 and logical reads 50 ,
it same or the second stats are better ? and the 50 is last value and not x2 .. yes?
Query 1 has 100 logical reads, query 2 has 50 logical reads. Ignore the scan count. If you're just looking at logical reads and nothing else (time, CPU), then query 2 does half the reads that query 1 does.
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