TABLEF Optimization

How to:

To improve performance, the SQL Translator can be set to generate FOCUS TABLEF commands instead of TABLE commands. Take advantage of this optimization using the SET SQLTOPTTF command (SQL Translator OPTimization TableF). See Improving Report Processing.

Syntax: How to Improve Performance Using SQLTOPTTF 

SET SQLTOPTTF = {ON|OFF}

where:

ON

Causes TABLEF commands to be generated when possible (for example, if there is no join or GROUP BY phrase). ON is the default value.

OFF

Causes TABLE commands to be generated.