Re: how to place a table in memory

if one cannot touch the code - or - a routine is frequently executed and has to run during hours when oltp users are also using the system - and it performs table scans, one could assign such a table to the keep pool and set it as "cache" as a work-around (duct tape) until the vendor comes up with a fix in a future release. worked for me.

-bdbafh Received on Thu Feb 10 2005 - 10:49:00 CST