SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-10
D
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
6
ANSI compliance 1-33
ANSI_STRING_FUNCTIONALITY 10-5
2
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-66
ATTEMPT_ESP_PARALLELISM 10-66
AUTOMATIC_RECOMPILATION 10-77
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
DEFAULT_BLOCKSIZE 10-80
DEF_MAX_HISTORY_ROWS 10-76
DOOM_USERTRANSACTION 10-77
DP2_CACHE_4096_BLOCKS 10-67
DYNAMIC_HISTOGRAM_COMPRESS
ION 10-53
FFDC_DIALOUTS_FOR_MXCMP 10-6
7
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-68
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-68
INFER_CHARSET 10-49
INSERT_VSBB 10-74
INTERACTIVE_ACCESS 10-78
ISOLATION_LEVEL 10-56
IUD_NONAUDITED_INDEX_MAINT 1
0-60
JOIN_ORDER_BY_USER 10-69
MATERIALIZE 10-79
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-
69
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