IFX_DIRECTIVES environment variable

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. 

1  setenv IFX_DIRECTIVES
2.1 1
2.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 HCL OneDB™ Administrator's Reference. For more information about the performance impact of directives, see your HCL OneDB Performance Guide.