Defining key lookup limits

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:

  1. Access the key lookup limit options, depending on the service type:
    Delete service
    1. 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.
    2. Select the Strategy tab.
    Archive service
    1. 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.
    2. Select the Delete tab.
    3. Ensure that Defer delete after archive is not selected.
    4. Click Delete Strategy to open the Table Delete Strategy window.
  2. 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 Access Method > Set All.
  3. Save the delete service.


Feedback