SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-10
D
Default settings (continued)
CACHE_HISTOGRAMS 10-43
CACHE_HISTOGRAMS_REFRESH_IN
TERVALS 10-43
CATALOG 10-51
CROSS_PRODUCT_CONTROL 10-58
DATA_FLOW_OPTIMIZATION 10-58
DDL_DEFAULT_LOCATIONS 10-54
DEF_MAX_HISTORY_ROWS 10-68
DOOM_USERTRANSACTION 10-69
DP2_CACHE_4096_BLOCKS 10-58
DYNAMIC_HISTOGRAM_COMPRESS
ION 10-44
FFDC_DIALOUTS_FOR_MXCMP 10-5
8
FLOATTYPE 10-42
GENERATE_EXPLAIN 10-59
GEN_EIDR_BUFFER_SIZE 10-59
GEN_MAX_NUM_PART_DISK_ENTRI
ES 10-54
GEN_MAX_NUM_PART_NODE_ENTR
IES 10-55
GEN_PA_BUFFER_SIZE 10-59
HIST_DEFAULT_SEL_FOR_LIKE_WIL
DCARD 10-44
HIST_DEFAULT_SEL_FOR_PRED_RA
NGE 10-44
HIST_JOIN_CARD_LOWBOUND 10-4
4
HIST_NO_STATS_REFRESH_INTERV
AL 10-45
HIST_NO_STATS_ROWCOUNT 10-45
HIST_NO_STATS_UEC 10-45
HIST_PREFETCH 10-45
HIST_ROWCOUNT_REQUIRING_STA
TS 10-46
HIST_SAME_TABLE_PRED_REDUCTI
ON 10-46
HIST_SCRATCH_VOL 10-46
HIST_SECURITY_WARNINGS 10-47
INDEX_ELIMINATION_LEVEL 10-59
Default settings (continued)
INFER_CHARSET 10-60
INSERT_VSBB 10-66
INTERACTIVE_ACCESS 10-70
ISOLATION_LEVEL 10-47
IUD_NONAUDITED_INDEX_MAINT 1
0-51
JOIN_ORDER_BY_USER 10-60
MATERIALIZE 10-71
MAX_ESPS_PER_CPU_PER_OP 10-
60
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS 10-48
MDAM_SCAN_METHOD 10-60
MEMORY_USAGE_SAFETY_NET 10-
61
MIN_MAX_OPTIMIZATION 10-61
MP_SUBVOLUME 10-51
MP_SYSTEM 10-51
MP_VOLUME 10-52
MSCF_ET_REMOTE_MSG_TRANSFE
R 10-61
MXCMP_PLACES_LOCAL_MODULES
10-49
NAMETYPE 10-51
NATIONAL_CHARSET 10-50
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-42
NUMBER_OF_USERS 10-62
OLT_QUERY_OPT 10-62
OPTIMIZATION_LEVEL 10-62
OPTS_PUSH_DOWN_DAM 10-62
PARALLEL_NUM_ESPS 10-62
PM_OFFLINE_TRANSACTION_GRAN
ULARITY 10-55
PM_ONLINE_TRANSACTION_GRANU
LARITY 10-55
POS_LOCATIONS 10-55
POS_NUM_OF_PARTNS 10-55
POS_RAISE_ERROR 10-56