Materialized Views

Hi, I heard somthing about materialized views for oracle and sql-Server. I think, this technique is very interesting, especially when you have to join certain "less-change"-tables very often. Is there any comparable technique for Informix (IDS 9.4)? Thanks in advance! Bye Markus

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. Art S. Kagel > Hi, > > I heard somthing about materialized views for oracle and sql-Server. I > think, this technique is very interesting, especially when you have to join > certain "less-change"-tables very often. > > Is there any comparable technique for Informix (IDS 9.4)? > > Thanks in advance! > > Bye > Markus

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