Selecting table access options

Use the Access Definition Editor to select the method for accessing the parent or child table for each relationship.

You can specify the following options:
Default
Optim™ determines the best method. A key lookup is used when a DBMS index is available, and a scan when an index is not available. However, if accessing a significant portion of the table, the default is to scan, even if an index exists.
Force scan
Read all rows in a table at one time.
Force key lookup
Locate rows using a WHERE clause to search for primary or foreign key values.
Note: Override the default method only if the statistical information in the process report indicates that the default method is less efficient.

To manage table access options:

  1. Expand the folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Relationships tab.
  3. Select the relationship.
  4. Select the Table Access tab.
  5. Enter table access options.
  6. Save the access definition.


Feedback