Thanks for the response
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> It sounds like you want to prerun the user's query. While this is > possible from a technical point of view, it is not a wise idea.
Actually, it is. It is called "materialized view" and is done on regular basis.
If you create it on prebuilt table which is in the "KEEP" pool, you get as
close to pre-caching the results of the desired query as possible.
Thanks, maa
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
