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

7 Managing Histograms.................................................................................................31
CACHE_HISTOGRAMS_REFRESH_INTERVAL................................................................................31
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
8 Sequence Generator....................................................................................................37
SEQUENCE_GENERATOR_CACHE...................................................................................................37
SEQUENCE_GENERATOR_CACHE_INCREMENT..........................................................................38
SEQUENCE_GENERATOR_CACHE_INITIAL...................................................................................39
SEQUENCE_GENERATOR_CACHE_MAXIMUM.............................................................................40
9 Managing Catalogs and Schemas............................................................................41
SCHEMA...............................................................................................................................................41
PUBLISHING_ROLES..........................................................................................................................41
10 Managing Materialized Views.................................................................................43
MV_ALLOW_SELECT_SYSTEM_ADDED_COLUMNS.....................................................................43
MVGROUP_AUTOMATIC_CREATION..............................................................................................43
11 Managing Isolation Level...........................................................................................45
ISOLATION_LEVEL.............................................................................................................................45
ISOLATION_LEVEL_FOR_UPDATES.................................................................................................46
12 Executor.......................................................................................................................47
EXE_MEMORY_LIMIT_PER_CPU.......................................................................................................47
13 Transaction Control and Locking..............................................................................49
INSERT_VSBB.......................................................................................................................................49
MULTI_COMMIT_SIZE........................................................................................................................50
NOT_ATOMIC_FAILURE_LIMIT........................................................................................................51
OPI_ERROR73_RETRIES......................................................................................................................51
TABLELOCK.........................................................................................................................................52
TIMEOUT..............................................................................................................................................53
BLOCK_TO_PREVENT_HALLOWEEN..............................................................................................54
UPD_ORDERED...................................................................................................................................54
14 Compiler Cache.........................................................................................................57
QUERY_CACHE...................................................................................................................................57
15 Miscellaneous.............................................................................................................59
DEF_MAX_HISTORY_ROWS..............................................................................................................59
LAST0_MODE......................................................................................................................................59
QUERY_LIMIT_SQL_PROCESS_CPU.................................................................................................60
STREAM_TIMEOUT.............................................................................................................................61
4 Table of Contents