SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-10
D
Default settings (continued)
HIST_SECURITY_WARNINGS 10-43
INDEX_ELIMINATION_LEVEL 10-55
INSERT_VSBB 10-59
INTERACTIVE_ACCESS 10-62
ISOLATION_LEVEL 10-44
IUD_NONAUDITED_INDEX_MAINT 1
0-47
JOIN_ORDER_BY_USER 10-55
MATERIALIZE 10-64
MAX_ESPS_PER_CPU_PER_OP 10-
55
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS 10-45
MDAM_SCAN_METHOD 10-55
MIN_MAX_OPTIMIZATION 10-55
MP_SUBVOLUME 10-48
MP_SYSTEM 10-48
MP_VOLUME 10-48
MSCF_ET_REMOTE_MSG_TRANSFE
R 10-56
MXCMP_PLACES_LOCAL_MODULES
10-46
NAMETYPE 10-47
NATIONAL_CHARSET 10-46
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-39
NUMBER_OF_USERS 10-56
OLT_QUERY_OPT 10-56
OPTIMIZATION_LEVEL 10-56
OPTS_PUSH_DOWN_DAM 10-56
PARALLEL_NUM_ESPS 10-57
POS_LOCATIONS 10-52
POS_NUM_OF_PARTNS 10-52
POS_RAISE_ERROR 10-52
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-57
PRESERVE_MIN_SCALE 10-40
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-39
Default settings (continued)
QUERY_CACHE 10-58
QUERY_CACHE_MAX_VICTIMS 10-5
8
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-58
READONLY_CURSOR 10-60
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-59
REMOTE_ESP_ALLOCATION 10-57
SAVE_DROPPED_TABLE_DDL 10-65
SCHEMA 10-48
SCRATCH_DISKS 10-60
SCRATCH_DISKS_EXCLUDED 10-60
SCRATCH_DISKS_PREFERRED 10-6
0
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-60
SIMILARITY_CHECK 10-63
STREAM_TIMEOUT 10-65
TABLELOCK 10-45
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-67
TIMEOUT 10-45
UDR_JAVA_OPTIONS 10-64
UPD_ABORT_ON_ERROR 10-62
UPD_ORDERED 10-57
UPD_SAVEPOINT_ON_ERROR 10-62
ZIG_ZAG_TREES 10-57
DEFAULT value, using 2-153, 2-234
DEFAULTS table
See SYSTEM_DEFAULT table
DEFINE names
ADD DEFINE command 4-3
SQL/MP objects 6-13
DEFINEs
description of 6-36
in INVOKE in Windows NT 3-67
DEFINITION_SCHEMA_VERSION_vernum
schema
description of 10-3