> > >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.

However, Oracle also has the "create_mv_refresh" clause,
which tells how and when to refresh the view.

You can make it refresh on any committed change in the "master"
tables.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com


[Non-text portions of this message have been removed]