Re: Q:Keeping a table in memory for speed

Don't recall the specifics, but "cacheing" frequently-used tables was recommended in a recent article in Ora-something mag (little thin 3rd-party rag--sorry to be so forgetful). I'd love to hear if that gives a big boost and what the best tables to do it with are.

mfs

Simon Spencer wrote:
>
> I dont suppose anyone can tell me how to make a table or group of tables
> memory resident?
>
> (Oracle 7.3, Under NT 4.0)
>
> Many thanks.
> --
> -----------------------------------------------------------------------
> Simon Spencer
> Vice President Work: 203-961-6140
> IPD, Operations and Technology Fax: 203-961-6163
> Emerging Technologies Group Cell:
> 100 First Stamford Place Email: simon.spencer_at_citicorp.com
> 7th Floor, Stamford CT.
> 06902 USA
> ----------------------------------------------------------------------
  Received on Fri May 02 1997 - 00:00:00 CDT