Re: Server cache for certain reference tables...

From: <denny_vk_at_hotmail.com>
Date: Tue, 21 Apr 1998 21:49:33 -0600
Message-ID: <6hjlrt$om0$1@nnrp1.dejanews.com>

Hi,

Try

alter table < table_name > cache;

Denny

In article <6hh2ss$6sq$1_at_nnrp1.dejanews.com>#1/1, kolli_s_at_hotmail.com wrote:
>
>
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 21 1998 - 22:49:33 CDT