SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

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