Create Materialized view of Materialized views

dienh · #1 (**permalink**) 11-13-03, 17:12

Hi,

I am using DB2 V8.1 on Linux. I have a number of materialized views created on a number of base tables. Is it possible to create another materialized view from the existing materialized views? Thank you.

Cheers,
Dien

Marcus_A · #2 (**permalink**) 11-13-03, 17:21

You can create a view on a another view, a base table, or a nickname. Views are not materialized, unless you are talking about something that I don't know about.

jsander · #3 (**permalink**) 11-14-03, 06:05

Hi,

you can create MQTs (Materialized Query Tables, the former Automated Summary Tables) on base tables only.

MQTs are DB2's equivalent of materialized views.

Johann

Quote:

Originally posted by dienh
Hi,

I am using DB2 V8.1 on Linux. I have a number of materialized views created on a number of base tables. Is it possible to create another materialized view from the existing materialized views? Thank you.

Cheers,
Dien

Internet Services

Web Development

Digital Marketing

Consumer Tech