Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Server cache for certain reference tables...

Re: Server cache for certain reference tables...

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 21 Apr 1998 06:51:53 GMT
Message-ID: <6hhfm9$iej$2@news00.btx.dtag.de>


Hi,

take a look at the CACHE-parameter of the CREATE TABLE stat.

kolli_s_at_hotmail.com schrieb:
>
> Hi,
>
> According to our database model we will end up joining the main data
> table with several smaller reference tables for almost every select
> query. I am trying to find if there is a way in Oracle to keep certain
> tables in buffer (cache or whatever) *all the time* so that our joins
> do not take too long. I know that it's possible in Sybase (11.x.x).
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de Received on Tue Apr 21 1998 - 01:51:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US