Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2005-03-09 : 17:57:38
|
| Hi,We have a table with 1.17M pages allocated as shown by dbcc showcontig but when are running a query on this table it shows following output:Table 'test1’. Scan count 1, logical reads 20858533, physical reads 3094838, read-ahead reads 805552. How can it is doing 20M reads and 3M physical reads with scan count 1 when table only have 1.17M pages allocated?Thanks--Harvinder |
|
|
PW
Yak Posting Veteran
95 Posts |
Posted - 2005-03-09 : 18:04:11
|
| Depends on the query and what it's being joined to. |
 |
|
|
|
|
|
set statistics io question