AskTom "Update statement tuning"

AskTom "Update statement tuning"

and multi_block_read are always physical I/O?
NO!

say your multi-block read count is set reasonable (1000 isn't even borderline
reasonable), say at 64.

[quote]
but block 15, 30, and 45 are in the cache.

we'll multiblock physical IO 1..14
single block logical IO 15
multiblock physical IO 16..29

and so on.
[/quote]