Re: Data storage question

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Mon, 23 Aug 1999 23:36:56 +0100
Message-ID: <E1L+WCAI0cw3Ewno@rwx777.demon.co.uk>

In article <7ps6of$cp1$1_at_autumn.news.rcn.net>, Jerry Gitomer <jgitomer_at_hbsrx.com> writes
>queries). In fact if you are using Oracle 8 you can lock your
>indexes in RAM and your system will fly.
>

How?, this is new one to me.

Assuming alter index keep or something, what if the indexes are too large for ram? - warehouses etc. Won't you lose any benefit in swapping?

This sounds best left to to memory algorithms as a first reaction. Can anyone enlighten me?

Thanks,
Steve
--
Please remove nospam from my address to Reply. Received on Mon Aug 23 1999 - 17:36:56 CDT