Neoview SQL Reference Manual (R2.4 SP2)

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 269) and “MAINTAIN MVGROUP”
(page 215).
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 an MV
group.
Example of CREATE MVGROUP
• This example creates a materialized view group:
CREATE MVGROUP pgroup
CREATE MVGROUP Statement 69