Re: Memory Resident Tables

Jeff Page (credware_at_terraport.net) writes:
> It was suggested to me that a performance enhancing technique
> exists that involves making frequently used tables "memory
> resident". I assume this refers to loading the entire table
> into the database buffer cache with a "select *" type of
> query. Has anyone made use of such a technique and have they
> succeeded in improving performance with it?

   In 7.1 or later: "ALTER TABLE mytab CACHE" will cause all blocks fetched for mytab to be placed at the MRU end of the buffer cache LRU list. I've never tried it myself bu the principal is sound as long as mytab is relatively small compared to your buffer cache.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##