You can specify the maximum number of key lookups (from
1 to 100) performed at one time for a table. By default, Optim looks
at one key at a time. For example, if you specify 5 for the limit
and the key spans a single column, 5 key values are searched in a
single request.
Note that increasing the key lookup limit can significantly
improve performance.
The following conditions must be true to
edit the key lookup limit for a table:
- An index on the primary key is defined for the table.
- Row compare is not selected for the delete process.
- Row-level archive actions are not defined for the
delete process (for example, Before Delete of Row).
- The DBMS for the table is Sybase ASE, Informix®, or SQL Server (if SQL Server is
not using array deletes).
- The table does not have any child tables.
- Access the key lookup limit options, depending on the service
type:
- Delete service
- Expand a folder in the Directory Explorer that contains the delete
service, expand the Delete Services node, and
double-click the delete service to edit.
- Select the Strategy tab.
- Archive service
- Expand a folder in the Directory Explorer that contains the archive
service, expand the Archive Services node,
and double-click the archive delete to edit.
- Select the Delete tab.
- Ensure that Defer delete after archive is
not selected.
- Click Delete Strategy to open the Table
Delete Strategy window.
- Define table access options, using one of the following
methods:
- To set an option for a single table, use the Access
Method column drop-down list, or right-click the row that
contains the table and click Access Method.
- To set an option for all tables, right-click the table list
and click .
- Save the delete service.