Related Information

For information about the sqexplain.out file, see SET EXPLAIN.

For information about how to create optimizer directives that the database server stores in the sysdirectives system catalog table for use with subsequent queries, see SAVE EXTERNAL DIRECTIVES.

For information about how to set optimization settings for an entire session, see the description of SET OPTIMIZATION.

For a discussion about optimizer directives and performance, see your IBM Informix Performance Guide.

For descriptions of the IFX_DIRECTIVES and IFX_EXTDIRECTIVES environment variables, see the IBM Informix Guide to SQL: Reference.

For information on the DIRECTIVES parameter in the onconfig file, see your IBM Informix Administrator's Reference.