Neoview Control Query Default (CQD) Reference Guide (R2.5)

Materialized View groups are automatically created and MVs
added or dropped from these groups.
‘ON’
User controls the creation of Materialized View groups and the
adding and dropping of MVs from these groups.
‘OFF’
The default value is ‘ON’.
Values
The purpose of automatically creating Materialized View groups and adding and dropping
MVs from these groups is to make Materialized View maintenance as transparent as possible.
The CQD can be turned OFF if you want to take full control of maintaining Materialized
View groups. For example, creating the groups and adding or removing MVs from the
groups.
The automatic creation feature is limited. It only groups together MVs that are defined
directly or indirectly on the same table. Indirectly means that if Materialized View1 is
defined on T1, and Materialized View2 is defined on Materialized View1, then both
Materialized View1 and Materialized View2 are included in the MVGROUP created for
T1.
You may want full control in order to group MVs using different criteria, such as by the
frequency at which those MVs are refreshed.
Usage
Not applicableProduction usage
Not applicableImpact
SystemLevel
Not applicableConflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 2.2Introduced in release
Not applicableDeprecated in release
44 Managing Materialized Views