"Art S. Kagel" <kagel@bloomberg.net> wrote

> On Fri, 21 May 2004 07:31:19 -0400, Markus Bschorer wrote:
>
> Table? Just create a table with the joined data columns and add triggers to
> the underlying tables to maintain them live. Better than materialized views.

Could you explain how this is better than MV. The whole concept of MV
is to avoid the cost of joining and aggrgrating big tables. That's why
MV is created as a point-in-time snapshot and the queries use it
automatically when needed.
If you are going to have a trigger, then the same performance penalty is
introduced. In that case why bother about any new table. Just let the
SQL do the work at query time.

or am I missing anything.