optimizeparameters

Boolean value that enables SQL to re-prepare a parameterized query after the parameter values have been populated (at exec time). This may produce a better execution plan than the one generated at prepare time, when the parameter values are unknown. Defaults to ON.

Default Value

If the optimizeparameters option is not defined, the default value of ON is used.

Example
optimizeparameters=ON
SQL Options

This option key is associated with the SQL Connection Handle and can be set or retrieved using:

See also
SQL SET statements
SQLSetConnectAttr()
SQLGetConnectAttr()
Note
SQL options can also be associated with the RDM_DB handle along with the Database Configuration Options.