Neoview SQL Reference Manual (R2.2)

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 182)
Loads indexes.“POPULATE INDEX Utility” (page 186)
Purges data from tables or indexes.“PURGEDATA Utility” (page 187)
Privileges Required to Execute Utilities
Privileges RequiredUtility
ALL privileges ALL privilegesMAINTAIN
REFRESH
REORG
UPDATE STATISTICS
schema ownerPOPULATE INDEX
ALL privilegesPURGEDATA
Privileges Required to Execute Utilities 181