Selecting relationship traversal options

Use the Access Definition Editor to manage relationship traversal options in an access definition.

You can specify the following options:
  • The maximum number of rows from the child table to be selected for a relationship.
  • The maximum number of key lookups performed at one time for a table.

    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.

  • The traversal paths:
    • Traverse the relationship from child to parent, in order to select a parent row for each child row to ensure the relational integrity. (Option 1)
    • Traverse the relationship to select additional child rows for each parent row selected as a result of a traversal from child to parent. (Option 2)

    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:

  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 Traversal Options tab.
  5. Enter traversal options.
  6. Save the access definition.


Feedback