--- In firebird-tools@yahoogroups.com, "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.

Regards,

Robert.