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
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 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.