Re: In-memory tables.

Although that is the answer to your question - aware that it does not FORCE the issue you will need to access the table after a system startup for the data to be loaded to memory and if the system requires a lot of Block Buffers for another purpose it WILL take it and age the table in question out of memory.

All that this command does it to put tables so specified at the recently used end of the LRU list. This is regardless of use, which in most cases will ensure the table data stays in memory once read.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Gennadiy Greenberg <gennadiy.greenberg_at_siemens.com.ua> wrote in message news:38C39EC0.4BEF2548_at_siemens.com.ua...
> Please, type:
>
> SQL>ALTER TABLE <your_table> CACHE;
>
> -----
> Gennadiy Greenberg
>
> chrisg wrote:
>
> > Is there any way to explictly specify that a table is held in memory?
> >
> > Thanks,
> >
> > Alister
>
Received on Mon Mar 06 2000 - 09:20:30 CST