SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-10
D
syntax diagram of 3-33
DEFAULT clause
ALTER TABLE use of 2-15
CREATE TABLE use of 2-99, 7-2
default value 7-3
examples of 7-4
syntax diagram of 7-2
Default settings
ALLOW_DP2_ROW_SAMPLING 10-6
8
ANSI compliance 1-34
ANSI_STRING_FUNCTIONALITY 10-5
3
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-68
ATTEMPT_ESP_PARALLELISM 10-68
AUTOMATIC_RECOMPILATION 10-80
CACHE_HISTOGRAMS 10-53
CACHE_HISTOGRAMS_REFRESH_IN
TERVALS 10-54
CATALOG 10-62
CROSS_PRODUCT_CONTROL 10-69
DATA_FLOW_OPTIMIZATION 10-69
DDL_DEFAULT_LOCATIONS 10-65,
10-69
DEFAULT_BLOCKSIZE 10-83
DEF_MAX_HISTORY_ROWS 10-79
DOOM_USERTRANSACTION 10-80
DP2_CACHE_4096_BLOCKS 10-70
DYNAMIC_HISTOGRAM_COMPRESS
ION 10-54
FFDC_DIALOUTS_FOR_MXCMP 10-7
0
FLOATTYPE 10-52
GENERATE_EXPLAIN 10-70
GEN_EIDR_BUFFER_SIZE 10-70
GEN_MAX_NUM_PART_DISK_ENTRI
ES 10-65
GEN_MAX_NUM_PART_NODE_ENTR
IES 10-66
GEN_PA_BUFFER_SIZE 10-71
HIST_DEFAULT_SEL_FOR_LIKE_WIL
DCARD 10-54
HIST_DEFAULT_SEL_FOR_PRED_RA
NGE 10-54
HIST_JOIN_CARD_LOWBOUND 10-5
4
HIST_NO_STATS_REFRESH_INTERV
AL 10-55
HIST_NO_STATS_ROWCOUNT 10-55
HIST_NO_STATS_UEC 10-55
HIST_PREFETCH 10-55
HIST_ROWCOUNT_REQUIRING_STA
TS 10-56
HIST_SAME_TABLE_PRED_REDUCTI
ON 10-56
HIST_SCRATCH_VOL 10-56
HIST_SECURITY_WARNINGS 10-57
INDEX_ELIMINATION_LEVEL 10-71
INFER_CHARSET 10-50
INSERT_VSBB 10-77
INTERACTIVE_ACCESS 10-81
ISOLATION_LEVEL 10-57
IUD_NONAUDITED_INDEX_MAINT 1
0-61
JOIN_ORDER_BY_USER 10-71
MATERIALIZE 10-82
MAX_ESPS_PER_CPU_PER_OP 10-
71
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS 10-58
MDAM_SCAN_METHOD 10-71
MEMORY_USAGE_SAFETY_NET 10-
72
MIN_MAX_OPTIMIZATION 10-72
MP_SUBVOLUME 10-62
MP_SYSTEM 10-62
MP_VOLUME 10-62
MSCF_ET_REMOTE_MSG_TRANSFE
R 10-72
MXCMP_PLACES_LOCAL_MODULES
10-59
, 10-61