Neoview Control Query Default (CQD) Reference Guide (R2.5)

Index
A
AUTO_QUERY_RETRY_WARNINGS, 61
B
BLOCK_TO_PREVENT_HALLOWEEN, 54
C
CACHE_HISTOGRAMS_REFRESH_INTERVAL, 31
CQDs
overview, 11
setting, 12
D
DEF_MAX_HISTORY_ROWS, 59
DEFAULT_DEGREE_OF_PARALLELISM, 13
E
EXE_MEMORY_LIMIT_PER_CPU, 47
H
HASH_JOINS, 21
HIST_AUTO_GENERATION_OF_SAMPLE, 31
HIST_MISSING_STATS_WARNING_LEVEL, 32
HIST_NO_STATS_REFRESH_INTERVAL, 33
HIST_PREFETCH, 34
HIST_ROWCOUNT_REQUIRING_STATS, 34
HIST_USE_SAMPLE_FOR_CARDINALITY_ESTIMATION,
35
I
INSERT_VSBB, 49
ISOLATION_LEVEL, 45
ISOLATION_LEVEL_FOR_UPDATES, 46
J
JOIN_ORDER_BY_USER, 21
L
LAST0_MODE, 59
M
MDAM_SCAN_METHOD, 22
MERGE_JOINS, 22
MULTI_COMMIT_SIZE, 50
MV_ALLOW_SELECT_SYSTEM_ADDED_COLUMNS,
43
MVGROUP_AUTOMATIC_CREATION, 43
N
NESTED_JOINS, 23
NOT_ATOMIC_FAILURE_LIMIT, 51
O
OPI_ERROR73_RETRIES, 51
OPTIMIZATION_LEVEL, 23
P
PARALLEL_NUM_ESPS, 13
POS_ABSOLUTE_MAX_TABLE_SIZE, 29
PUBLISHING_ROLES, 41
Q
QUERY_CACHE, 57
QUERY_LIMIT_SQL_PROCESS_CPU, 60
R
RISK_PREMIUM_NJ, 24
RISK_PREMIUM_SERIAL, 25
ROBUST_QUERY_OPTIMIZATION, 26
S
SAVE_DROPPED_TABLE_DDL, 62
SCHEMA, 41
SEQUENCE_GENERATOR_CACHE, 37
SEQUENCE_GENERATOR_CACHE_INCREMENT, 38
SEQUENCE_GENERATOR_CACHE_INITIAL, 39
SEQUENCE_GENERATOR_CACHE_MAXIMUM, 40
Setting CQDs
implementing , 12
testing , 12
SKEW_EXPLAIN, 15
SKEW_SENSITIVITY_THRESHOLD, 15
STREAM_TIMEOUT, 61
SUBQUERY_UNNESTING, 28
T
TABLELOCK, 52
TIMEOUT, 53
U
UPD_ORDERED, 54
USTAT_AUTO_CV_SAMPLE_SLOPE, 17
USTAT_AUTO_PRIORITY, 17
USTAT_MAX_READ_AGE_IN_MIN, 18
USTAT_MIN_ROWCOUNT_FOR_SAMPLE, 19
USTAT_NECESSARY_SAMPLE_MAX, 19
USTAT_OBSOLETE_PERCENT_ROWCOUNT, 20
63