Neoview SQL Reference Manual (R2.3)

There are three ways that tasks could be specified. the group of tasks to be executed depend on
the object-type.
If ALL is specified, all tasks relevant to that object-type are performed. The detailed tasks
for each object-type are:
• TABLE — The object-name specified is the table that needs to be maintained. Tasks done
are reorg of the table, reorg of all indexes on the table, update of table statistics, update of
mvlog statistics, refresh of all mviews on that table, reorg of all mviews on the table, reorg
of all indexes on the mviews, and update of statistics for all mviews on the table.
• INDEX — The object-name specified is the index that needs to me 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 mviews in that group.
• MV — The object-name specified is the mview 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.
One or more tasks could be explicitly specified for each object-type. For example, REORG
and UPDATE STATISTICS could be specified for object-type TABLE, which will reorg the
table and perform update statistics for 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 ANSI name of the object to be maintained. It can be a one or two-part name.
REORG
Reorg the specified table.
REORG ALL INDEXES
Reorg 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
Reorg all materialized views on the specified table.
REORG ALL MVS INDEXES
Reorg all indexes on all materialized views on the specified table.
task options
optional string containing options specific to the individual tasks that would be passed on
to that particular command at run time. Task options are added to the internal query to be
executed. Task options are entered using single quotes. The content of the task options is
appended to the existing internal query. The format chosen must match what the internal
query requires to properly execute.
In the case of REORG TABLE, the task options must be entered as a comma-separated list
preceded by a leading comma.
MAINTAIN Command 193