Optimizing Retrieval Speed for FOCUS Data Sources

When the AUTOPATH parameter in set ON, an optimized retrieval path—that is, one in which the lowest retrieved segment is the entry point—is selected dynamically. It is equivalent to the alternate view syntax

TABLE FILE filename.fieldname

where:

 fieldname

Is not indexed. Retrieval starts at the segment in which fieldname resides.

The system determines whether optimized retrieval is appropriate by analyzing the fields referenced in a request and the data source structure. For more information on the AUTOPATH parameter, see the Developing Applications manual.

Tip: Another way to optimize data retrieval is by using intelligent partitioning in requests that do not require retrieval from every partition. For information on efficiency considerations for FOCUS data sources, including intelligent partitioning, see the Describing Data manual.


Information Builders