Thread: [PERFORMANCE] is it possible to force an index to be held in memory?

Hi,

I have found some discussions about that issue, but did not find the
answer actually.

Is there a way to be sure, that some indexes are alway in memory? My
tests bringing them to the memory based file system (ramfs) tablespace
showed really a very significant performance gain. But a perspective
to have a corrupted database after each machine restart does not
really make me feel good.

With best regards,

-- Valentine Gogichashvili