distinctcachesize

Integral value that specifies the number of intermediate rows from a DISTINCT query stored in the cache. The value must be 100 or greater.

Default Value

If the DistinctCacheSize option is not defined, the default value of 10000 is used.

Example

DistinctCacheSize=10000

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.