One or more missing DBMS indexes is the most frequent cause of performance problems in an Archive or Extract Process. Use the Relationship Index Analysis dialog to analyze DBMS indexes for relationships that are used with the Access Definition and 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.
Select Relationship Index Analysis from the Tools menu in the Access Definition Editor to display the Relationship Index Analysis dialog.

The status of DBMS indexes for the parent and child table columns in each relationship is displayed as follows:
If the analysis determines that a DBMS index for a parent or a child table is needed to increase the efficiency of processing, the Needed check box is selected. If the check box is cleared, the index was not analyzed, or is not needed.
Using the shortcut menu, you can create needed DBMS indexes, and create, edit or browse relationships. Right-click the grid on the Relationship Index Analysis dialog to display shortcut menu.
If the status of an index is shown as Partial, or None, select from the following shortcut menu options to create necessary indexes:
In a generated SQL statement, the default name for a new index is in the form identifier.I_tablenamnnnnnnnn, where:

New indexes are named using the identifier (Creator ID, Owner ID, or Schema Name), followed by the letter I, the first eight letters of the table name, and end with an eight-digit number, as follows:
identifier.I_tablenamnnnnnnnn
The Review Index SQL dialog also indicates whether an expression in a relationship cannot be indexed.
Modify the name of the index, or other parts of the statements as necessary, then click Proceed to create the indexes.
The Browse Output dialog displays the results after the SQL statements are executed.