sortcostfactor
Numeric value that specifies the cost of extra sorting performed by RDM SQL on an ORDER BY or a GROUP BY query. The value will be used by the RDM SQL Optimizer in calculating the best execution plan for a given query.
- Default Value
- If the
SortCostFactoroption is not defined, the default value of0.000062is used.
- Example
-
SortCostFactor=0.000062
- 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.