Managing materialized views (MVs)

Materialized views (MVs) are database objects that store the results of a query, just as a regular table. A materialized view can be queried directly without querying the base table. For more information on MVs, see SQL/MX 3.5 Release Technical Update.You can view and display the properties of an MV using MXDM.

Related topics

Viewing materialized view properties

Displaying materialized views in a schema

Granting privileges on materialized views

Revoking privileges on materialized views