IFX_DIRECTIVES

The IFX_DIRECTIVES environment variable setting determines whether the optimizer allows query optimization directives from within a query. The IFX_DIRECTIVES environment variable is set on the client.

You can specify either ON and OFF or 1 and 0 to set the environment variable.

>>-setenv--IFX_DIRECTIVES--+-1-+-------------------------------><
                           '-0-'
 

1

Optimizer directives accepted

0

Optimizer directives not accepted

The setting of the IFX_DIRECTIVES environment variable overrides the value of the DIRECTIVES configuration parameter that is set for the database server. If the IFX_DIRECTIVES environment variable is not set, however, then all client sessions will inherit the database server configuration for directives that the ONCONFIG parameter DIRECTIVES determines. The default setting for the IFX_DIRECTIVES environment variable is ON.

For more information about the DIRECTIVES parameter, see the IBM Informix: Administrator's Reference. For more information on the performance impact of directives, see your IBM Informix: Performance Guide.