Neoview SQL Reference Manual (R2.5)

— Update of mvlog statistics
— Refresh of all materialized views on that table
— Reorg of all materialized views on the table
— Reorg of all indexes on the materialized views
— Update of statistics for all materialized views referencing the table.
• INDEX — The object-name specified is the index that needs to be maintained. The task
performed is the reorg of that index.
• MVGROUP — The object-name specified is the MVGROUP that needs to be maintained.
Tasks done are to refresh all materialized views in that group.
• MV — The object-name specified is the materialized view that needs to be maintained.
Tasks done are refresh, reorg, reorg of indexes, and update statistics.
You can explicitly specify one or more tasks for each object-type. For example, you can specify
REORG and UPDATE STATISTICS for object-type TABLE, which will reorganize the table
and perform update statistics on the table.
object-name
specifies the ANSI name of the object to be maintained. It can be a one or two-part name. See
“Database Object Names” (page 242).
maintain-task
specifies the maintenance task to perform.
REORG
Reorganize the specified table.
REORG ALL INDEXES
Reorganize all indexes on the specified table.
UPDATE STATISTICS
Update statistics for the specified table.
UPDATE STATISTICS ALL MVS
Update the statistics for all the materialized views referencing the specified table.
REFRESH
Refresh the specified table.
REFRESH ALL MVS
Refreshes all materialized views referencing the specified table.
REORG ALL MVS
Reorganize all materialized views referencing the specified table.
REORG ALL MVS INDEXES
Reorganize all indexes on all materialized views referencing the specified table.
task-options
optional string containing options specific to the individual maintain task (for example,
REORG or UPDATE STATISTICS), which will be passed on to that particular command at
run time. Specify the task options for each maintain task within single quotes. The task options
are appended to the internal command to be executed. The task options must comply with
the syntax of the internal command. For the syntax of the UPDATE STATISTICS task options,
see the “UPDATE STATISTICS Statement” (page 204).
In the case of REORG, the task options must be entered within single quotes as a
comma-separated list preceded by a leading comma. For the syntax of the REORG task option,
see RATE percentage.
214 SQL Utilities