Neoview SQL Reference Manual (R2.4)

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, materialized views 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 210)
Loads indexes.“POPULATE INDEX Utility” (page 218)
Purges data from tables or indexes.“PURGEDATA Utility” (page 219)
Privileges Required to Execute Utilities
Privileges RequiredUtility
To refresh, you must be the schema owner, object owner, or have the
SELECT, INSERT, and DELETE privilege on the materialized view.
To reorganize, you must be the object owner or have all table privileges
(SELECT/INSERT/DELETE/UPDATE).
To update statistics, you must be the object owner, the schema owner,
or have SELECT privilege on the table.
MAINTAIN
REFRESH
REORG
UPDATE STATISTICS
You must be the object owner, schema owner, 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, and have the SELECT
and DELETE privileges.
PURGEDATA
Privileges Required to Execute Utilities 209