Use commands on the Tools menu in
the Access Definition Editor to analyze the combination
of tables, relationship selection, table specifications, and selection
criteria or to select Start Table rows for processing.
Indented Table Display
Select Indent from the Tools menu
to view the Indented Table Display dialog. The Indented
Table Display dialog has three tabs:
Relationship Index Analysis
One or more missing DBMS indexes is the most frequent cause
of performance problems in an Archive or Extract Process. Use the Relationship
Index Analysis dialog to analyze DBMS indexes for relationships
that are used with the Access Definition and to create any needed
indexes. The Relationship Index Analysis dialog
lists each selected relationship in the Access Definition, with an
analysis of DBMS indexes for the corresponding parent and child tables.
Show Steps
Select Show Steps from the Tools menu
to analyze the traversal path to be used in the process. Use Show
Steps to evaluate the tables and relationships and display
the steps that are performed to select the data. This evaluation can
ensure that you retrieve the desired set of data.
Edit Point and Shoot List
Select Edit Point and Shoot from
the Tools menu to display the Point
and Shoot Editor. You can use the Point and Shoot
Editor to create or edit a Point and Shoot list or to browse
data to analyze the effects of criteria as you define it.