Re: How to store a table in memory only?

Actaully, the original poster asked about a table in memory ONLY. A cached table is stored on disk.

In addition, when you alter a table with the cache clause, it does NOT move it into memory. In fact, it may NEVER get into memory. What the cache clause does is tall oracle that when a FULL TABLE SCAN is done, the contents of the table should be placed at the most recently used end of the LRU list, rather than the norm, which is at the least recently used end of the LRU list.

Jim wrote:

> ALTER TABLE <table name> CACHE;
>
> On 22 Jan 2001 06:38:43 GMT, hartgeorge_at_aol.com (Hartgeorge) wrote:
>
> >Hi,
> >
> >I cannot figure out how to create a table that is stored only in memory.
> >Basically I am looking for the mysql equiv of:
> > create table foo(x char(2)) type=heap;
> >
> >Any ideas?
> >Thank you- George Hart.
> >
  Received on Mon Jan 22 2001 - 16:31:24 CST