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 ORDER BY property;

            PROPERTY                     VALUE
 ------------------------------- ----------------------

 ATOM_GC_LOCK_TIMEOUT            10000
 AUTOCOMMIT_DDL                  FALSE
 COMPAT_CARDINALITY_CLAMP        FALSE
 DB_TRACE                        OFF
 DB_TRACE_MIN_TIME               0.000000
 DB_TRACE_PATTERN
 DB_TRACE_PROCEDURES
 DB_TRACE_TABLE                  TRACESCHEMA.TRACETABLE
 DEFAULT_CONNECTION_MEMORY_LIMIT 0.000000
 DEFAULT_LOCK_WAIT_TIMEOUT       0
 DEFAULT_VIEW_SECURITY           INVOKER
 DISKSPILL_MEMORY_THRESHOLD_MB   64
 ENFORCE_TABLE_LOCKS_FOR_DDL     FALSE
 IDLE_CONNECTION_TIMEOUT         0
 INDEX_ENCODING                  -1
 MAX_CONNECTION_OPEN_RESULTSETS  1000
 MAX_CONNECTION_OPEN_STATEMENTS  1000
 MAX_MATERIALIZED_QUERY_SIZE     67108864
 MAX_QUERY_COUNT                 9
 MAX_STMT_CACHE_SIZE             500
 MIN_QUERY_TIME                  10.000000
 MIN_QUERY_WARN_TIME             315360000.000000
 OPT_MAX_SCAN_REOPTIMIZE         20
 OPT_REMOVE_INDEXED_PRED         ALL
 OPT_STATS_INDEX                 TRUE
 ROLLBACK_DEADLOCK_VICTIM        TRUE
 SKIP_UNCOMMITTED_INSERTS        FALSE
 SQL_DISKSPILL                   TRUE
 SQL_STATEMENT_LOG_MIN_TIME      0.000000
 TABLE_CHG_TOLERANCE             0.100000
 TRANSACTIONAL_DDL               TRUE
 TRANSACTIONAL_LOCKS             TRUE
 UDF_CACHE_SIZE                  50
 USE_COVERING_INDEX              TRUE