Neoview SQL Reference Manual (R2.3)

CREATE MVGROUP Statement
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 264)and “MAINTAIN MVGROUP”
(page 194).
CREATE MVGROUP mv-group-name
mv-group-name
specifies the materialized view group name to create.
Authorization and Availability Requirements
The schema owner or anyone having the CREATE privilege can create an MV group.
Example of CREATE MVGROUP
• This example creates a materialized view group:
CREATE MVGROUP pgroup
66 SQL Statements