List:General Discussion« Previous MessageNext Message »
From:Pooly Date:October 20 2005 10:54pm
Subject:Re: Input on Materialized Views
View as plain text  
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/
Thread
Input on Materialized ViewsAndrew Roth19 Oct
  • Re: Input on Materialized ViewsJigal van Hemert19 Oct
    • Re: Input on Materialized ViewsSGreen19 Oct
      • Re: Input on Materialized ViewsAndrew Roth19 Oct
        • Re: Input on Materialized ViewsSGreen19 Oct
          • Re: Input on Materialized ViewsAndrew Roth20 Oct
Re: Input on Materialized ViewsHeikki Tuuri20 Oct
  • Re: Input on Materialized ViewsPooly21 Oct
RE: Input on Materialized ViewsJon Frisby21 Oct