Cashing result set in RAM

From: <odessa7_at_my-dejanews.com>
Date: Thu, 29 Apr 1999 21:25:35 GMT
Message-ID: <7gaioa$7gc$1@nnrp1.dejanews.com>

We use Oracle 8.0.5 on NT and will switch to Lunix. We have a catalog table with 20,000 rows (2 columns: char(10), varchar2(1000)).

The data is fairly static, but there will be big "select..like '%d%' " activity (1000++ request per minute). Looks like the indexes can't be used (because like starts with %).

So, is there a way to cashe the whole table in RAM/buffer so that all select are executed there?

Thanx

L.B.
oracle_at_russiantreasure.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 16:25:35 CDT