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.