Re: Login Trigger

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Fri, 12 Mar 2004 11:15:44 -0500
Message-ID: <20040312161544.GC2257@mladen.wangtrading.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 12 2004 - 10:16:57 CST