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
optimizeparametersoption is not defined, the default value ofONis 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.