optthreshold
Integral value that specifies the number of times the SQL Query Optimizer iterates through the list of possible execution plans in order to determine the best execution plan. If the value is 0, the Query Optimizer will check the entire list.
- Default Value
- If the
OptThresholdoption is not defined, the default value of0is used.
- Example
-
OptThreshold=0
- 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.