User guide

Improving Performance
Using ENFORM Efficiently
5–14 058058 Tandem Computers Incorporated
Determine if FIND Files Can Be Shared
Analyze the queries made to determine whether they are sufficiently similar to share
the same FIND (intermediate) files. Sharing FIND files improves performance because
the query processor must select the data used for many reports only once. Sharing
FIND files is particularly useful when the STRATEGY COST (see “Using the ENFORM
Statistics” in this section) of the query is high and the intermediate file is small relative
to the size of the original files.
Consider using FUP to load frequently used FIND file data into a structured file to also
improve performance.