Neoview SQL Reference Manual (R2.5)

• If the POPULATE INDEX operation fails unexpectedly, you may need to drop the index
again and recreate and repopulate, or run recover. Contact HP support for details on how
to run recover.
• Online POPULATE INDEX reads the audit trail to replay updates by allowing read/write
access. If you plan to create many indexes in parallel or if you have a high level of activity
on the audit trail, you should consider using the OFFLINE option.
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;
POPULATE INDEX Utility 221