Having performance problems, we are trying to find a solution to keep the
indexes in memory only. We would like to avoid disk i/o for the indexes.
Of course, we could keep them in memory at application level without using
Oracle for the indexes (no primary key) but using Oracle just for the data.
Is there any possibility to keep the indexes in memory (Oracle SGA) and to
specify to Oracle that they do not have to be written on disk. Since, the
memory has a limited size, this index should be 'dropped' on a regular basis,
I suppose.
Thanks for your help. (We are working on a Unix machine, developping in C)
Jean-Francois DENIS (jean-francois.denis_at_s1.bru1.sni.be)
Received on Thu Jan 26 1995 - 13:41:16 CET