i have a little hard time figuring out whether sp_cachestrategy
disables "large i/o" or "prefetch"..


the parameter value to sp_cachestrategy is "prefetch" but when you run
it to display the current status of a table, it displays the
enabled/disabled status under column header "large IO"..

the ref manual says "sp_cachestrategy enables or disables prefetching
(large I/O) ..."

now prefething and large i/o are same things ???

i'm really confused here...

any help is appreciated, thanks

i.d.