Neoview SQL Reference Manual (R2.5)

CREATE MVGROUP Statement
• “Considerations for MVGROUP”
• “Example of CREATE MVGROUP”
The CREATE MVGROUP statement groups together materialized views that are defined on a
common table to preserve database consistency.
For information on MVGROUPS, see “MVGROUPs ” (page 282) and “MAINTAIN MVGROUP”
(page 217).
CREATE MVGROUP mv-group-name
mv-group-name
specifies the materialized view group name to create.
Considerations for MVGROUP
The schema owner or anyone having the CREATE privilege on the schema can create a
materialized view group.
Example of CREATE MVGROUP
• This example creates a materialized view group:
CREATE MVGROUP pgroup
CREATE MVGROUP Statement 69