You are here: Reference Information > SQL Reference Information > SQL System Tables > PROPERTIES System Table Description

PROPERTIES System Table Description

Description

Settings for NuoDB defined properties. Users may not modify the rows in the SYSTEM.PROPERTIES table directly but can change the values by using the SET SYSTEM PROPERTY command. See SQL System Properties for a description of each system property.

Fields

Field Type Description
PROPERTY string Name of the property to be set.
VALUE string Setting of the property.

Indexes

Unique Index: SYSPROPIDX on field: PROPERTY

Example

The default SYSTEM.PROPERTIES values are:

SELECT * FROM system.properties;
 
           PROPERTY               VALUE 
 ------------------------------ --------- 
 MAX_QUERY_COUNT                10 
 MIN_QUERY_TIME                 10.000000 
 OPT_STATS_INDEX                TRUE 
 MAX_STMT_CACHE_SIZE            500 
 TABLE_CHG_TOLERANCE            0.100000 
 MAX_CONNECTION_OPEN_RESULTSETS 1000
 MAX_CONNECTION_OPEN_STATEMENTS 1000 
 INDEX_ENCODING                 -1 
 OPT_MAX_SCAN_REOPTIMIZE        20 
 SKIP_UNCOMMITTED_INSERTS       FALSE
 UDF_CACHE_SIZE                 50 
 COMPAT_CARDINALITY_CLAMP       FALSE
 MAX_MATERIALIZED_QUERY_SIZE    67108864