A materialized view is a table containing the results of a query. PowerDesigner supports materialized views for the DB2, HP Neoview, Netezza, Oracle, and Sybase SQL Anywhere DBMS families.
Materialized views are supported in the following ways:
- DB2 - Select materialized query table (or for earlier versions, summary table) in the Type list on the General tab of a view property sheet.
- HP Neoview - Use the List of Materialized Views (available from ).
- Netezza - Use the List of Materialized Views (available from ).
- Oracle - Use the List of Materialized Views (available from ).
- SQL Anywhere - Select Materialized View in the Type list on the General tab of a view property sheet to display the DB space field, and specify the dbspace in which to create the materialized view. The default is the current dbspace.