Re: Login Trigger

From: Maryann Atkinson <maryann_30_at_yahoo.com>
Date: Fri, 12 Mar 2004 11:28:36 -0500
Message-Id: <5.2.1.1.2.20040312112644.00bc8028@pop.netaddress.com>

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.

---

Now I am lost... can you perhaps provide some steps?

Thanks,
maa

---

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:25:58 CST