Subject Re: [Firebird-Architect] Re: Indexed Views
Author Ann W. Harrison
At 04:50 AM 12/22/2004, donjules2k wrote:

>As a thought could
>the engine not implement the keyword "materialized" when creating a
>view and do this plumbing work in the background for you? In theory
>shouldn't be too difficult as you are using parts of the engine that
>already exists.

Inverting the definition of a view to triggers on the
base tables is not all that easy in the general case. It certainly
isn't anything that the engine currently does.

Regards,

Ann