Re: Login Trigger
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 12 Mar 2004 11:15:44 -0500
On 03/12/2004 11:03:49 AM, Daniel Fink wrote:
> 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.
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
