I read the definition of logical readings:
http://msdn.microsoft.com/en-us/library/ms184361.aspx
He says:
"The number of pages read from the data cache."
I have two tables (the number of rows of table_1 is 141 , and table_2 is 16.811 ), when I run these two queries, it gives the following result.
SELECT * FROM Table_1
results
Scan count 1, logical reads 6, physical reads 0, read-ahead reads 0.
SELECT * FROM Table_2
results
scan count 1, logical reads 701, physical reads 0, read-ahead reads 0
if the logic reading is "The number of pages read from the data cache." What is a page? How is it calculated?
source
share