Memory Resident Tables

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?

Thanks in advance,

Jeff Page Received on Wed Jan 03 1996 - 00:00:00 CET