Subject Re: Materialized views
Author robertgilland
--- In, "Ann W. Harrison"
<aharrison@i...> wrote:
> At 11:51 PM 11/29/2004, robertgilland wrote:
> >Is there any method of creating Materialized views in Firebird?
> The other solution is to declare the "materialized view" as a
> table and use triggers to maintain its values - either on the
> view or on the source tables.
> Regards,
> Ann

After reading up on Materialised views in Oracle, I can see these
are just query snapshots placed in tables.
There are not maintained in Oracle either.
Our current method is to save the query to a CDS file.
It seems this still is the best method.
The trigger method seems to me would be highly complicated and
slow our system down.