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: