Re: Oracle and (Cached?) Views

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 09 Jul 2002 06:46:21 +0200
Message-ID: <vjqkiuckskgui1liprc0n8e9n9kqjmbdh3@4ax.com>

On Tue, 09 Jul 2002 01:39:28 GMT, Bob Kosman <lucent_at_dtransform.com> wrote:

>Running Oracle 8, we have a view which takes a reasonable
>amount of time. An associate mentioned to me that he thought
>it was possible to make Oracle cache a view such that
>subsequent re-running of it would be more efficient.
>
>Has anyone heard of this?
>
>TIA.
>
>Kos.

Oracle 8i has materialized views.
Oracle 8 has been desupported

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 08 2002 - 23:46:21 CDT