Neoview SQL Reference Manual (R2.4)

mvlog statistics, refresh of all MVs on that table, reorg of all MVs on the table, reorg of all
indexes on the MVs, and update of statistics for all MVs on 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 MVs in that group.
• MV — The object-name specified is the MV that needs to be maintained. Tasks done are
refresh, reorg, reorg of indexes, and update statistics.
• MVINDEX — The object-name specified is the MV index. The task done is reorg of that
index.
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.
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 on the specified table.
REFRESH
Refresh the specified table.
REFRESH ALL MVS
Refreshes all materialized views on the specified table.
REORG ALL MVS
Reorganize all materialized views on the specified table.
REORG ALL MVS INDEXES
Reorganize all indexes on all materialized views on 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 202).
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.
other-options
CONTINUE ON ERROR
If any of the maintain tasks return an error, that error is returned, and execution continues
to the next task. The default is to continue on error.
212 SQL Utilities