Neoview SQL Reference Manual (R2.4)

POPULATE INDEX Utility
• “Syntax Description of POPULATE INDEX”
• “Considerations for POPULATE INDEX”
• “Examples of POPULATE INDEX”
POPULATE INDEX is a syntax-based utility that can be executed in the Neoview Command
Interface. The POPULATE INDEX utility loads Neoview SQL indexes.
POPULATE INDEX index ON table [index-option]
index-option is ONLINE | OFFLINE
Syntax Description of POPULATE INDEX
index
is an SQL identifier that specifies the simple name for the index. You cannot qualify index
with its schema names. Indexes have their own namespace within a schema, so an index
name might be the same as a table or constraint name. However, no two indexes in a schema
can have the same name.
table
is the name of the table for which to populate the index. See “Database Object Names”
(page 228).
ONLINE
specifies that the populate should be done online. That is, while the base table is available
for DML operations. The default is ONLINE.
OFFLINE
specifies that the populate should be done offline. The base table is unavailable for write
operations at this time. OFFLINE must be specified explicitly.
Considerations for POPULATE INDEX
• To populate an index, you must be the schema owner, object owner, have the ALTER
privilege, or have the SELECT, INSERT, and DELETE privilege.
• When an online POPULATE INDEX is being executed, the base table is accessible for read
write DML operations during that time period, except during the commit phase at the very
end.
Errors can occur if the source base table or target index cannot be accessed, or if the load fails
due to some resource problem or problem in the file system.
Examples of POPULATE INDEX
• This example loads the specified index from the specified table:
POPULATE INDEX myindex ON myschema.mytable;
• This example loads the specified index from the specified table, which uses the default
schema:
POPULATE INDEX index2 ON table2;
218 SQL Utilities