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 SortCostFactor option is not defined, the default value of 0.000062 is 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.