GilaMonster (10/31/2013)

---

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.