Neoview SQL Reference Manual (R2.4)

ALTER MVGROUP Statement
• “Syntax Description of ALTER MVGROUP” (page 43)
• “Considerations for ALTER MVGROUP” (page 43)
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 264).
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.
mv-name
specifies the ANSI logical name for the materialized view.
Considerations for ALTER MVGROUP
• Only ON REQUEST and RECOMPUTE MV can be added to a materialized view group. ON
STATEMENT MV is 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 61) for information on single-delta materialized views.
Example 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
ALTER MVGROUP Statement 43