Neoview SQL Reference Manual (R2.3)

3 SQL Utilities
A utility is a tool that runs within Neoview SQL and performs such tasks as maintenance, loading
indexes, purging data from tables, indexes, and reorganizing and reloading data in a table or
index.
This section describes the Neoview SQL utilities:
Performs one or more maintenance tasks, such as REORG,
UPDATE STATISTICS, and REFRESH, on a specified
database object.
“MAINTAIN Command” (page 192)
Loads indexes.“POPULATE INDEX Utility” (page 197)
Purges data from tables or indexes.“PURGEDATA Utility” (page 198)
Privileges Required to Execute Utilities
Privileges RequiredUtility
To refresh, you must be the schema owner, object owner, services ID,
or have the SELECT, INSERT, and DELETE privilege on the
materialized view.
To reorg, you must be the object owner.
To update statistics, you must be the object owner, the schema owner,
services ID, or have SELECT privilege on the table.
MAINTAIN
REFRESH
REORG
UPDATE STATISTICS
You must be the object owner, schema owner, services ID, have the
ALTER privilege, or have the SELECT, DELETE, and INSERT privilege
on the table or materialized view.
POPULATE INDEX
You must be the object owner, the schema owner, or have the SELECT
and DELETE privileges.
PURGEDATA
Privileges Required to Execute Utilities 191