Re: Input on Materialized Views

[Pooly]

2005/10/20, Heikki Tuuri <heikki.tuuri@stripped>:
> Andrew,
>
> how about using triggers to recompute materialized views? A challenge is to
> write an automatic program that can compute the required triggers based on
> the view definition. The materialized view would be a normal table. Triggers
> would update it.
>
> Regards,

Better, mark this view (or particular rows if it's not too expensive)
as "dirty" and recompute it only on access, you may spare few
cycles...

--
Pooly
Webzine Rock : http://www.w-fenec.org/