SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-10
D
Default settings (continued)
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-63
ATTEMPT_ESP_PARALLELISM 10-63
AUTOMATIC_RECOMPILATION 10-74
CACHE_HISTOGRAMS 10-49
CACHE_HISTOGRAMS_REFRESH_IN
TERVALS 10-50
CATALOG 10-57
CROSS_PRODUCT_CONTROL 10-64
DATA_FLOW_OPTIMIZATION 10-64
DDL_DEFAULT_LOCATIONS 10-60
DEFAULT_BLOCKSIZE 10-77
DEF_MAX_HISTORY_ROWS 10-73
DOOM_USERTRANSACTION 10-74
DP2_CACHE_4096_BLOCKS 10-64
DYNAMIC_HISTOGRAM_COMPRESS
ION 10-50
FFDC_DIALOUTS_FOR_MXCMP 10-6
4
FLOATTYPE 10-48
GENERATE_EXPLAIN 10-65
GEN_EIDR_BUFFER_SIZE 10-65
GEN_MAX_NUM_PART_DISK_ENTRI
ES 10-61
GEN_MAX_NUM_PART_NODE_ENTR
IES 10-61
GEN_PA_BUFFER_SIZE 10-65
HIST_DEFAULT_SEL_FOR_LIKE_WIL
DCARD 10-50
HIST_DEFAULT_SEL_FOR_PRED_RA
NGE 10-50
HIST_JOIN_CARD_LOWBOUND 10-5
0
HIST_NO_STATS_REFRESH_INTERV
AL 10-51
HIST_NO_STATS_ROWCOUNT 10-51
HIST_NO_STATS_UEC 10-51
HIST_PREFETCH 10-51
HIST_ROWCOUNT_REQUIRING_STA
TS 10-52
Default settings (continued)
HIST_SAME_TABLE_PRED_REDUCTI
ON 10-52
HIST_SCRATCH_VOL 10-52
HIST_SECURITY_WARNINGS 10-53
INDEX_ELIMINATION_LEVEL 10-65
INFER_CHARSET 10-46
INSERT_VSBB 10-71
INTERACTIVE_ACCESS 10-75
ISOLATION_LEVEL 10-53
IUD_NONAUDITED_INDEX_MAINT 1
0-57
JOIN_ORDER_BY_USER 10-66
MATERIALIZE 10-76
MAX_ESPS_PER_CPU_PER_OP 10-
66
MAX_ROWS_LOCKED_FOR_STABLE
_ACCESS 10-54
MDAM_SCAN_METHOD 10-66
MEMORY_USAGE_SAFETY_NET 10-
66
MIN_MAX_OPTIMIZATION 10-67
MP_SUBVOLUME 10-58
MP_SYSTEM 10-58
MP_VOLUME 10-58
MSCF_ET_REMOTE_MSG_TRANSFE
R 10-67
MXCMP_PLACES_LOCAL_MODULES
10-55, 10-56
NAMETYPE 10-57
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-47
NUMBER_OF_USERS 10-67
OLT_QUERY_OPT 10-67
OPTIMIZATION_LEVEL 10-68
OPTS_PUSH_DOWN_DAM 10-68
PARALLEL_NUM_ESPS 10-68
PM_OFFLINE_TRANSACTION_GRAN
ULARITY 10-61
PM_ONLINE_TRANSACTION_GRANU
LARITY 10-61