Neoview SQL Reference Manual (R2.5)
ALTER MVGROUP Statement
• “Syntax Description of ALTER MVGROUP”
• “Considerations for ALTER MVGROUP”
• “Examples of ALTER MVGROUP”
The ALTER MVGROUP statement allows you to add or remove a member from the materialized
view group (MVGROUP). The ADD clause should be used when adding one or more MVs to
the MVGROUP. The REMOVE clause should be used when removing one or more MVs from
an MVGROUP.
For information on MVGROUPS, see “MVGROUPs ” (page 282).
ALTER MVGROUP mv-group-name
{ADD mv-name [, mv-name] ... |
REMOVE mv-name [, mv-name]...}
Syntax Description of ALTER MVGROUP
mv-group-name
specifies the materialized view group name to alter. For naming conventions, see “Database
Object Names” (page 242).
mv-name
specifies the ANSI logical name for the materialized view. For naming conventions, see
“Database Object Names” (page 242).
Considerations for ALTER MVGROUP
• Only ON REQUEST and RECOMPUTE MVs can be added to a materialized view group.
ON STATEMENT MVs are not allowed to participate in a group.
• A materialized view is allowed to participate in a group only if:
— all materialized views directly or indirectly used by the materialized view are in the
group, or
— the materialized view is a single-delta materialized view. See “CREATE MATERIALIZED
VIEW Statement” (page 63) for information on single-delta materialized views.
Examples of ALTER MVGROUP
• This example adds a member to the materialized view group:
ALTER MVGROUP pgroup
ADD mv1
• This example removes a member from the materialized view group:
ALTER MVGROUP pgroup
REMOVE mv2
42 SQL Statements