Missing database indexes are the most frequent cause of performance problems in an archive, extract, or delete process. Use the index analysis tools that are provided with your Optim™ solution to analyze indexes for relationships and primary keys and to create any needed indexes.
If the status of an index is shown as Partial, or None, you can create any needed indexes from a menu option.
For archive or extract processing, use the Relationship Index Analysis dialog to analyze database indexes for relationships used with the access definition. You can also use this dialog to create any needed indexes. The Relationship Index Analysis dialog lists each selected relationship in the access definition, with an analysis of DBMS indexes for the corresponding parent and child tables.
Click in the Access Definition Editor to open the Relationship Index Analysis dialog.

The Primary Key Index Analysis dialog lists each table in the source file, with an analysis of DBMS indexes for each table. Use the Primary Key Index Analysis dialog to identify tables in an archive or extract file that have an index on the primary key. You can also use the Primary Key Index Analysis dialog to create any needed indexes.
Right-click a table name in the Table Access Strategy dialog and click Analyze Primary Key Index for this table or Analyze Primary Key Index for all tables to open the Primary Key Index Analysis dialog.

The possible status of the indexes for the Relationship Index Analysis and Primary Key Index Analysis dialogs are:
On the Relationship Index Analysis dialog, the Full status describes any DBPK, Unique, or Full index on the primary key.