Re: LRU algorithm - question

Hi Roger,

That's not right.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/
@   
@   Going to OpenWorld?
@   Catch the Ixora performance tuning seminar too!
@   See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: "Roger" <NOrgSPAM_at_mcs-hh.de>

Blocks from a full table scan are not cached.

Regards

   Roger

<sergey_s_at_my-deja.com> schrieb im Newsbeitrag news:8qjp3s$b30$1_at_nnrp1.deja.com...
> Data blocks placed in cache at the most recently used end "age out" by
> moving to the least recently used end where they get removed from
> memory.
>
> What happens to the blocks from full table scans? I know they are placed
> at the least recently used end, but do they remain in cache for some
> time? Is there also some sort of "aging out" process?
>
> Thnk you!
> Sergey
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Sep 24 2000 - 22:33:17 CDT