Re: Q: iot and memory lru ?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 07 Dec 1999 12:15:48 GMT
Message-ID: <384cf715.290726572@news.eagles.bbs.net.au>

Hi Ted,

An IOT is physically an index. However, indexes can be accessed via fast full scan, in which case they are treated just like full table scans in terms of caching.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

On Thu, 02 Dec 1999 19:44:58 GMT, tedchyn_at_yahoo.com wrote:

>Sir,
>when iot is loaded into memory, it is like an index or
>it is like a table in terms of aging out memory(LRU) ?
>
>Thanks ted
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Dec 07 1999 - 06:15:48 CST