Show TOC

Materialized ViewsLocate this document in the navigation structure

A materialized view is a table containing the results of a query. PowerDesigner supports materialized views for the DB2, HP Neoview, Netezza, Oracle, and 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 Start of the navigation path Model Next navigation step Materialized Views End of the navigation path).
  • Netezza - Use the List of Materialized Views (available from Start of the navigation path Model Next navigation step Materialized Views End of the navigation path).
  • Oracle - Use the List of Materialized Views (available from Start of the navigation path Model Next navigation step Materialized Views End of the navigation path).
  • 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.