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
 MIN_QUERY_WARN_TIME             315360000.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
 DB_TRACE                        OFF
 DB_TRACE_TABLE                  TRACESCHEMA.TRACETABLE
 DB_TRACE_PATTERN
 DB_TRACE_MIN_TIME               0.000000
 DB_TRACE_PROCEDURES
 SQL_STATEMENT_LOG_MIN_TIME      0.000000
 TRANSACTIONAL_DDL               TRUE
 USE_COVERING_INDEX              TRUE
 OPT_REMOVE_INDEXED_PRED         ALL
 DEFAULT_CONNECTION_MEMORY_LIMIT 0.000000
 TRANSACTIONAL_LOCKS             TRUE
 ROLLBACK_DEADLOCK_VICTIM        TRUE
 ENFORCE_TABLE_LOCKS_FOR_DDL     FALSE
 SQL_DISKSPILL                   TRUE
 DISKSPILL_MEMORY_THRESHOLD_MB   64
 IDLE_CONNECTION_TIMEOUT         0
 AUTOCOMMIT_DDL                  FALSE
 ATOM_GC_LOCK_TIMEOUT            10000