属性系统表描述

描述

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 放 SYSTEM PROPERTY command. See SQL系统属性 有关每个系统属性的描述。

领域

场地 类型 描述

财产

细绳

要设置的属性的名称。

价值

细绳

设置物业。

索引

Unique Index: SYSPROPIDX on field: 财产

例子

The default SYSTEM.PROPERTIES values are:

选择 * FROM system.properties;

            PROPERTY                     价值
 ------------------------------- ----------------------
 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