Archive allows you to override the default method used to access tables for processing (that is, scan or key lookup). Additionally, if Key Lookup is the method used, you can specify the maximum number of key lookups performed at one time. Override the default method only if the statistical information in the process report indicates the default method is less efficient.
Use the Table Access and Key Lookup Limit grid columns on the Relationships tab of the Access Definition Editor to modify the default access method for an Archive or Extract process. These grid columns are displayed automatically if at least either contains a value other than the default. If the columns are not displayed, click to display the Table Access and Key Lookup Limit grid columns on the Relationships tab.
In the Delete Request Editor, click to display the Table Access Strategy dialog with the Access Method and Key Lookup Limit grid columns.
In an Access Definition, you can override the default method for accessing the parent or child table for each relationship (that is, scan or key lookup). For a Delete Process, you can override the default method for deleting rows from each table.
The maximum number of key lookups performed at one time for a table. Valid values are 1 through 100. By default, Archive looks up one key at a time.
Increasing the Key Lookup Limit might significantly improve performance. For example, if you enter 5 as the Key Lookup Limit and the key has a single column, 5 key values are searched in a single request to the DBMS. For most sites, increasing the Key Lookup Limit to the maximum (100) is most effective.
Editing the Key Lookup Limit column for a table in a Delete Process requires the following: