Use the Access Definition Editor to manage relationship traversal options in an access definition.
Increasing the key lookup limit may significantly improve performance. For example, if you specify 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.
Options 1 and 2 are relevant when the start table is a child table or when a table has more than one parent table that is referenced by the access definition.
Option 2 is relevant only if you traverse a relationship from child to parent. For example, if a process traverses from child to parent (option 1) and a parent row is selected, option 2 causes the process to select additional child rows for that parent row.
If you select option 2 for a relationship, consider a child limit on the number of child rows to extract.
To manage relationship traversal options in an access definition: