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 -> Server cache for certain reference tables...

Server cache for certain reference tables...

From: <kolli_s_at_hotmail.com>
Date: Mon, 20 Apr 1998 22:13:33 -0600
Message-ID: <6hh2ss$6sq$1@nnrp1.dejanews.com> 







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
Received on Mon Apr 20 1998 - 23:13:33 CDT












Original text of this message













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