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. |
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