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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-69
Examples of SHOWCONTROL
•
Display all settings and defaults in effect:
>>showcontrol all;
..
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL TABLE settings are in effect.
No CONTROL QUERY DEFAULT settings are in effect.
Current DEFAULTS
ATTEMPT_ASYNCHRONOUS_ACCESS ON
ATTEMPT_ESP_PARALLELISM SYSTEM
AUTOMATIC_RECOMPILATION ON
CACHE_HISTOGRAMS ON
CACHE_HISTOGRAMS_REFRESH_INTERVAL 3600
CATALOG CAT
CHECK_CONSTRAINT_PRUNING ON
CROSS_PRODUCT_CONTROL ON
DATA_FLOW_OPTIMIZATION ON
DDL_DEFAULT_LOCATIONS
DEF_MAX_HISTORY_ROWS 1024
DOOM_USERTRANSACTION OFF
DP2_CACHE_4096_BLOCKS 1024
DYNAMIC_HISTOGRAM_COMPRESSION ON
FFDC_DIALOUTS_FOR_MXCMP OFF
FLOATTYPE IEEE
GENERATE_EXPLAIN ON
GEN_EIDR_BUFFER_SIZE 31000
GEN_MAX_NUM_PART_DISK_ENTRIES 3
GEN_MAX_NUM_PART_NODE_ENTRIES 255
GEN_PA_BUFFER_SIZE 31000
HIST_BASE_REDUCTION ON
HIST_DEFAULT_SEL_FOR_LIKE_WILDCARD 0.10
HIST_DEFAULT_SEL_FOR_PRED_RANGE 0.3333
HIST_JOIN_CARD_LOWBOUND 1.0
HIST_NO_STATS_REFRESH_INTERVAL 3600
HIST_NO_STATS_ROWCOUNT 100
HIST_NO_STATS_UEC 100
HIST_PREFETCH ON
HIST_ROWCOUNT_REQUIRING_STATS 50000
HIST_SAME_TABLE_PRED_REDUCTION 0.0
HIST_SCRATCH_VOL
HIST_SECURITY_WARNINGS ON
INDEX_ELIMINATION_LEVEL MAXIMUM
INFER_CHARSET OFF
INSERT_VSBB SYSTEM
INTERACTIVE_ACCESS OFF
ISOLATION_LEVEL READ_COMMITTED
IUD_NONAUDITED_INDEX_MAINT OFF
JOIN_ORDER_BY_USER OFF
MATERIALIZE SYSTEM
MAX_ESPS_PER_CPU_PER_OP 1
MAX_ROWS_LOCKED_FOR_STABLE_ACCESS 1