Topics:

• Rotating a Data Structure for Enhanced Retrieval
• Optimizing Retrieval Speed for FOCUS Data Sources
• Automatic Indexed Retrieval
• Data Retrieval Using TABLEF
• Preserving the Internal Matrix of Your Last Report
• Compiling Expressions
• Producing Multiple Outputs in One Pass of a Data Source (Pooled Tables)

The following high-performance methods optimize data retrieval and report processing:

• Temporary rotation of network and hierarchical data sources to create an alternate view of the data.
• Automatic alternate file views with the AUTOPATH feature.
• Automatic indexed retrieval (AUTOINDEX).
• Retrieval of pre-sorted data using the TABLEF command.
• Preserving the internal matrix of a report using the SAVEMATRIX parameter.
• Compiling expressions into machine code to provide faster processing.
• The Pooled Tables option to produce many reports or extract files in a single pass of your data source, reducing database I/O, CPU, and elapsed time.

Note: These techniques may not be available for all data sources. See your data adapter documentation to determine if a technique is valid for your data source.