SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-10
D
Default settings (continued)
CACHE_HISTOGRAMS_REFRESH_IN
TERVALS 10-42
CATALOG 10-48
CROSS_PRODUCT_CONTROL 10-54
DATA_FLOW_OPTIMIZATION 10-54
DDL_DEFAULT_LOCATIONS 10-51
DEF_MAX_HISTORY_ROWS 10-63
DOOM_USERTRANSACTION 10-64
DP2_CACHE_4096_BLOCKS 10-55
DYNAMIC_HISTOGRAM_COMPRESS
ION 10-42
FFDC_DIALOUTS_FOR_MXCMP 10-5
5
FLOATTYPE 10-41
GENERATE_EXPLAIN 10-55
GEN_EIDR_BUFFER_SIZE 10-55
GEN_MAX_NUM_PART_DISK_ENTRI
ES 10-52
GEN_MAX_NUM_PART_NODE_ENTR
IES 10-52
GEN_PA_BUFFER_SIZE 10-56
HIST_DEFAULT_SEL_FOR_LIKE_WIL
DCARD 10-42
HIST_DEFAULT_SEL_FOR_PRED_RA
NGE 10-42
HIST_JOIN_CARD_LOWBOUND 10-4
2
HIST_NO_STATS_REFRESH_INTERV
AL 10-43
HIST_NO_STATS_ROWCOUNT 10-43
HIST_NO_STATS_UEC 10-43
HIST_PREFETCH 10-43
HIST_ROWCOUNT_REQUIRING_STA
TS 10-44
HIST_SAME_TABLE_PRED_REDUCTI
ON 10-44
HIST_SCRATCH_VOL 10-44
HIST_SECURITY_WARNINGS 10-45
INDEX_ELIMINATION_LEVEL 10-56
INSERT_VSBB 10-61
Default settings (continued)
INTERACTIVE_ACCESS 10-65
ISOLATION_LEVEL 10-45
IUD_NONAUDITED_INDEX_MAINT 1
0-48
JOIN_ORDER_BY_USER 10-56
MATERIALIZE 10-66
MAX_ESPS_PER_CPU_PER_OP 10-
56
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS 10-46
MDAM_SCAN_METHOD 10-56
MIN_MAX_OPTIMIZATION 10-56
MP_SUBVOLUME 10-49
MP_SYSTEM 10-49
MP_VOLUME 10-49
MSCF_ET_REMOTE_MSG_TRANSFE
R 10-57
MXCMP_PLACES_LOCAL_MODULES
10-47
NAMETYPE 10-48
NATIONAL_CHARSET 10-47
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-40
NUMBER_OF_USERS 10-57
OLT_QUERY_OPT 10-57
OPTIMIZATION_LEVEL 10-57
OPTS_PUSH_DOWN_DAM 10-57
PARALLEL_NUM_ESPS 10-58
PM_OFFLINE_TRANSACTION_GRAN
ULARITY 10-52
PM_ONLINE_TRANSACTION_GRANU
LARITY 10-52
POS_LOCATIONS 10-53
POS_NUM_OF_PARTNS 10-53
POS_RAISE_ERROR 10-53
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-58
PRESERVE_MIN_SCALE 10-41
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-40