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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-65
Examples of SHOWCONTROL
•
Display all settings and defaults in effect:
>>showcontrol all;
..
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION 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
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