-- @@@ START COPYRIGHT @@@
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--
-- @@@ END COPYRIGHT @@@
DEFAULT_DEFAULTSFILE:
  
CONTROL QUERY DEFAULT ALLOW_INCOMPATIBLE_COMPARISON 'OFF';
CONTROL QUERY DEFAULT ARKCMP_FAKE_HW 'OFF';
CONTROL QUERY DEFAULT AUTOMATIC_RECOMPILATION 'OFF';
CONTROL QUERY DEFAULT BMO_MEMORY_USAGE_PERCENT '5.';
CONTROL QUERY DEFAULT EXPLAIN_DETAIL_COST_FOR_CALIBRATION 'FALSE';
CONTROL QUERY DEFAULT CPUCOST_COMPARE_COMPLEX_DATA_TYPE_OVERHEAD '10.';
CONTROL QUERY DEFAULT CPUCOST_COMPARE_COMPLEX_DATA_TYPE_PER_BYTE '.1';
CONTROL QUERY DEFAULT CPUCOST_COMPARE_SIMPLE_DATA_TYPE '.200';
CONTROL QUERY DEFAULT CPUCOST_COPY_ROW_OVERHEAD '0.';
CONTROL QUERY DEFAULT CPUCOST_COPY_ROW_PER_BYTE '.0007';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_COST_PER_BYTE '.002';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_INTERNODE_COST_PER_BYTE '.008';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_REMOTENODE_COST_PER_BYTE '.01';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_COST_PER_ROW '.002';
CONTROL QUERY DEFAULT CPUCOST_COPY_SIMPLE_DATA_TYPE '.005';
CONTROL QUERY DEFAULT CPUCOST_EVAL_ARITH_OP '.0305';
CONTROL QUERY DEFAULT CPUCOST_EVAL_FUNC_DEFAULT '10.';
CONTROL QUERY DEFAULT CPUCOST_EVAL_LOGICAL_OP '1.';
CONTROL QUERY DEFAULT CPUCOST_EVAL_SIMPLE_PREDICATE '1.';
CONTROL QUERY DEFAULT CPUCOST_LIKE_COMPARE_OVERHEAD '10.';
CONTROL QUERY DEFAULT CPUCOST_LIKE_COMPARE_PER_BYTE '.1';
CONTROL QUERY DEFAULT CPUCOST_HASH_PER_KEY '1.29';
CONTROL QUERY DEFAULT CPUCOST_HASH_PER_BYTE '.057325';
CONTROL QUERY DEFAULT CPUCOST_ENCODE_PER_BYTE '.002';
CONTROL QUERY DEFAULT CPUCOST_DM_GET '.001';
CONTROL QUERY DEFAULT CPUCOST_DM_UPDATE '.001';
CONTROL QUERY DEFAULT CPUCOST_ESP_INITIALIZATION '10';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_MAPPING_FUNCTION '.01';
CONTROL QUERY DEFAULT CPUCOST_EXCHANGE_SPLIT_FUNCTION '.01';
CONTROL QUERY DEFAULT CPUCOST_LOCK_ROW '.01';
CONTROL QUERY DEFAULT CPUCOST_PREDICATE_COMPARISON '.08';
CONTROL QUERY DEFAULT CPUCOST_SUBSET_OPEN '7000';
CONTROL QUERY DEFAULT CPUCOST_SUBSET_OPEN_AFTER_FIRST '1250';
CONTROL QUERY DEFAULT CPUCOST_TUPLE_REFERENCE '.001';
CONTROL QUERY DEFAULT DP2_MESSAGE_BUFFER_SIZE '56';
CONTROL QUERY DEFAULT LOCAL_MESSAGE_BUFFER_SIZE '50';
CONTROL QUERY DEFAULT OS_MESSAGE_BUFFER_SIZE '32';
CONTROL QUERY DEFAULT CPUCOST_DATARQST_OVHD '.01';
CONTROL QUERY DEFAULT DP2_CACHE_512_BLOCKS '152';
CONTROL QUERY DEFAULT DP2_CACHE_1024_BLOCKS '152';
CONTROL QUERY DEFAULT DP2_CACHE_2048_BLOCKS '150';
CONTROL QUERY DEFAULT DP2_CACHE_4096_BLOCKS '4096';
CONTROL QUERY DEFAULT DP2_CACHE_SIZE_IN_KB '8000';
CONTROL QUERY DEFAULT CPUCOST_SCAN_KEY_LENGTH '0.';
CONTROL QUERY DEFAULT CPUCOST_SCAN_OVH_PER_KB '0.984215';
CONTROL QUERY DEFAULT CPUCOST_SCAN_OVH_PER_ROW '0.0';
CONTROL QUERY DEFAULT CPUCOST_SCAN_DSK_TO_DP2_PER_KB '2.5';
CONTROL QUERY DEFAULT CPUCOST_SCAN_DSK_TO_DP2_PER_SEEK '0.0';
CONTROL QUERY DEFAULT CONFIGURED_MEMORY_FOR_BASE '16384';
CONTROL QUERY DEFAULT CONFIGURED_MEMORY_FOR_DAM '20480';
CONTROL QUERY DEFAULT CONFIGURED_MEMORY_FOR_MINIMUM_HASH '20480';
CONTROL QUERY DEFAULT CONFIGURED_MEMORY_FOR_MXESP '8192';
CONTROL QUERY DEFAULT COST_TUPP_DESC_LENGTH_IN_KB '0.01171875';
CONTROL QUERY DEFAULT COST_PROBE_DENSITY_THRESHOLD '.25';
CONTROL QUERY DEFAULT IO_TRANSFER_COST_PREFETCH_MISSES_FRACTION '0.';
CONTROL QUERY DEFAULT IO_SEEKS_INORDER_FACTOR '0.10';
CONTROL QUERY DEFAULT DEFAULTS_TABLE_ACCESS_WARNINGS 'OFF';
CONTROL QUERY DEFAULT NEXT_DEFAULTS_TABLE '';
CONTROL QUERY DEFAULT DEF_CHUNK_SIZE '5000000.0';
CONTROL QUERY DEFAULT DEF_CPU_ARCHITECTURE 'MIPS';
CONTROL QUERY DEFAULT DEF_DISCS_ON_CLUSTER '8';
CONTROL QUERY DEFAULT DEF_INSTRUCTIONS_SECOND '480';
CONTROL QUERY DEFAULT DEF_LOCAL_CLUSTER_NUMBER '1';
CONTROL QUERY DEFAULT DEF_LOCAL_SMP_NODE_NUMBER '15';
CONTROL QUERY DEFAULT DEF_MAX_HISTORY_ROWS '1024';
CONTROL QUERY DEFAULT DEF_NUM_BM_CHUNKS '0';
CONTROL QUERY DEFAULT DEF_NUM_NODES_IN_ACTIVE_CLUSTERS '16';
CONTROL QUERY DEFAULT DEF_NUM_SMP_CPUS '1';
CONTROL QUERY DEFAULT DEF_PAGE_SIZE '16';
CONTROL QUERY DEFAULT DEF_PHYSICAL_MEMORY_AVAILABLE '8388608';
CONTROL QUERY DEFAULT DEF_TOTAL_MEMORY_AVAILABLE '8388608';
CONTROL QUERY DEFAULT DEF_VIRTUAL_MEMORY_AVAILABLE '125000';
CONTROL QUERY DEFAULT DP2_BLOCK_HEADER_SIZE '96';
CONTROL QUERY DEFAULT DP2_END_OF_BUFFER_HEADER_SIZE '.0313';
CONTROL QUERY DEFAULT DP2_EXCHANGE_REQUEST_SIZE '.0469';
CONTROL QUERY DEFAULT DP2_FRACTION_SEEK_FROM_RANDOM_TO_INORDER '25';
CONTROL QUERY DEFAULT DP2_MAX_READ_PER_ACCESS_IN_KB '256';
CONTROL QUERY DEFAULT DP2_MESSAGE_HEADER_SIZE '.0176';
CONTROL QUERY DEFAULT DP2_MESSAGE_HEADER_SIZE_BYTES '18';
CONTROL QUERY DEFAULT DP2_MINIMUM_FILE_SIZE_FOR_SEEK_IN_BLOCKS '256';
CONTROL QUERY DEFAULT MAX_CHAR_PARAM_DEFAULT_SIZE '32';
CONTROL QUERY DEFAULT MAX_LONG_VARCHAR_DEFAULT_SIZE '2000';
CONTROL QUERY DEFAULT MIN_LONG_VARCHAR_DEFAULT_SIZE '1';
CONTROL QUERY DEFAULT MAX_LONG_WVARCHAR_DEFAULT_SIZE '2000';
CONTROL QUERY DEFAULT MIN_LONG_WVARCHAR_DEFAULT_SIZE '1';
CONTROL QUERY DEFAULT EX_OP_ALLOCATE_BUFFER_POOL '.1';
CONTROL QUERY DEFAULT EX_OP_ALLOCATE_BUFFER '50.';
CONTROL QUERY DEFAULT EX_OP_ALLOCATE_TUPLE '.05';
CONTROL QUERY DEFAULT EX_OP_ALLOCATE_ATP '.02';
CONTROL QUERY DEFAULT EX_OP_COPY_ATP '1.1335';
CONTROL QUERY DEFAULT EX_OP_ENQUEUE '.02';
CONTROL QUERY DEFAULT EX_OP_DEQUEUE '.02';
CONTROL QUERY DEFAULT FAST_DP2_SUBSET_OPT 'ON';
CONTROL QUERY DEFAULT FAST_REPLYDATA_MOVE 'ON';
CONTROL QUERY DEFAULT FIND_COMMON_SUBEXPRS_IN_OR 'ON';
CONTROL QUERY DEFAULT FFDC_DIALOUTS_FOR_MXCMP 'OFF';
CONTROL QUERY DEFAULT FORCE_BUSHY_CQS 'ON';
CONTROL QUERY DEFAULT GEN_CBUF_BUFFER_SIZE '30000';
CONTROL QUERY DEFAULT GEN_CBUF_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_CBUF_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_CBUF_SIZE_UP '8';
CONTROL QUERY DEFAULT GEN_DDL_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_DDL_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_DDL_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_DDL_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_DEL_BUFFER_SIZE '512';
CONTROL QUERY DEFAULT GEN_DEL_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_DEL_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_DEL_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_DESC_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_DESC_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_DESC_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_DESC_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_DP2I_BUFFER_SIZE '10000';
CONTROL QUERY DEFAULT GEN_DP2I_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_DP2I_SIZE_DOWN '32';
CONTROL QUERY DEFAULT GEN_DP2I_SIZE_UP '64';
CONTROL QUERY DEFAULT GEN_DPDU_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_DPDU_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_DPDU_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_DPDU_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_DPRO_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_DPRO_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_DPRO_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_DPRO_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_DPSO_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_DPSO_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_DPSO_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_DPSO_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_DPSS_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_DPSS_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_DPSS_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_DPSS_SIZE_UP '32';
CONTROL QUERY DEFAULT GEN_DPUO_BUFFER_SIZE '10000';
CONTROL QUERY DEFAULT GEN_DPUO_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_DPUO_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_DPUO_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_DPVI_BUFFER_SIZE '10000';
CONTROL QUERY DEFAULT GEN_DPVI_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_DPVI_SIZE_DOWN '32';
CONTROL QUERY DEFAULT GEN_DPVI_SIZE_UP '64';
CONTROL QUERY DEFAULT GEN_EIDR_BUFFER_SIZE '31000';
CONTROL QUERY DEFAULT GEN_EIDR_NUM_BUFFERS '3';
CONTROL QUERY DEFAULT GEN_EIDR_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_EIDR_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_FSRT_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_FSRT_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_FSRT_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_FSRT_SIZE_UP '8';
CONTROL QUERY DEFAULT GEN_HGBY_BUFFER_SIZE '32768';
CONTROL QUERY DEFAULT GEN_HGBY_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_HGBY_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_HGBY_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_HSHJ_BUFFER_SIZE '32768';
CONTROL QUERY DEFAULT GEN_HSHJ_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_HSHJ_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_HSHJ_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_IMDT_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_IMDT_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_IMDT_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_IMDT_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_INS_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_INS_NUM_BUFFERS '3';
CONTROL QUERY DEFAULT GEN_INS_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_INS_SIZE_UP '128';
CONTROL QUERY DEFAULT GEN_LOCK_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_LOCK_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_LOCK_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_LOCK_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_MATR_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_MATR_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_MATR_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_MATR_SIZE_UP '8';
CONTROL QUERY DEFAULT GEN_MEM_PRESSURE_THRESHOLD '10';
CONTROL QUERY DEFAULT GEN_MJ_BUFFER_SIZE '32768';
CONTROL QUERY DEFAULT GEN_MJ_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_MJ_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_MJ_SIZE_UP '1024';
CONTROL QUERY DEFAULT GEN_ONLJ_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_ONLJ_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_ONLJ_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_ONLJ_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_PA_BUFFER_SIZE '31000';
CONTROL QUERY DEFAULT GEN_PA_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_PA_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_PA_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_RCRS_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_RCRS_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_RCRS_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_RCRS_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_ROOT_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_ROOT_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_ROOT_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_ROOT_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_SAMPLE_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_SAMPLE_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_SAMPLE_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_SAMPLE_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_SCANBT_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_SCANBT_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_SCANBT_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_SCANBT_SIZE_UP '32';
CONTROL QUERY DEFAULT GEN_SCAN_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_SCAN_NUM_BUFFERS '10';
CONTROL QUERY DEFAULT GEN_SCAN_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_SCAN_SIZE_UP '32';
CONTROL QUERY DEFAULT GEN_SEQFUNC_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_SEQFUNC_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_SEQFUNC_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_SEQFUNC_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_SEQ_BUFFER_SIZE '512';
CONTROL QUERY DEFAULT GEN_SEQ_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_SEQ_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_SEQ_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_SGBY_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_SGBY_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_SGBY_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_SGBY_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_SNDB_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_SNDB_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_SNDB_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_SNDB_SIZE_UP '128';
CONTROL QUERY DEFAULT GEN_SNDT_BUFFER_SIZE_DOWN '0';
CONTROL QUERY DEFAULT GEN_SNDT_BUFFER_SIZE_UP '0';
CONTROL QUERY DEFAULT GEN_SNDT_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_SNDT_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_SNDT_SIZE_UP '128';
CONTROL QUERY DEFAULT GEN_SORT_MAX_BUFFER_SIZE '5242880';
CONTROL QUERY DEFAULT GEN_SORT_MIN_BUFFER_SIZE '0';
CONTROL QUERY DEFAULT GEN_SORT_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_SORT_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_SORT_SIZE_UP '1024';
CONTROL QUERY DEFAULT GEN_SPLB_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_SPLB_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_SPLB_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_SPLB_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_SPLT_BUFFER_SIZE '2';
CONTROL QUERY DEFAULT GEN_SPLT_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_SPLT_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_SPLT_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_STPR_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_STPR_NUM_BUFFERS '3';
CONTROL QUERY DEFAULT GEN_STPR_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_STPR_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_TFLO_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_TFLO_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_TFLO_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_TFLO_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_TIMEOUT_BUFFER_SIZE '4096';
CONTROL QUERY DEFAULT GEN_TIMEOUT_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_TIMEOUT_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_TIMEOUT_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_TRAN_BUFFER_SIZE '4096';
CONTROL QUERY DEFAULT GEN_TRAN_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_TRAN_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_TRAN_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_TRSP_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_TRSP_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_TRSP_SIZE_DOWN '16';
CONTROL QUERY DEFAULT GEN_TRSP_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_TUPL_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_TUPL_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT GEN_TUPL_SIZE_DOWN '2048';
CONTROL QUERY DEFAULT GEN_TUPL_SIZE_UP '2048';
CONTROL QUERY DEFAULT GEN_UNLJ_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_UNLJ_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_UNLJ_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_UNLJ_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_UN_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_UN_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_UN_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_UN_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_UPD_BUFFER_SIZE '5120';
CONTROL QUERY DEFAULT GEN_UPD_NUM_BUFFERS '5';
CONTROL QUERY DEFAULT GEN_UPD_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_UPD_SIZE_UP '2';
CONTROL QUERY DEFAULT GEN_XPLN_BUFFER_SIZE '4096';
CONTROL QUERY DEFAULT GEN_XPLN_NUM_BUFFERS '3';
CONTROL QUERY DEFAULT GEN_XPLN_SIZE_DOWN '8';
CONTROL QUERY DEFAULT GEN_XPLN_SIZE_UP '16';
CONTROL QUERY DEFAULT GEN_CS_BUFFER_SIZE '0';
CONTROL QUERY DEFAULT GEN_CS_NUM_BUFFERS '0';
CONTROL QUERY DEFAULT GEN_CS_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_CS_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_UDR_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_UDR_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_UDR_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_UDR_SIZE_UP '4';
CONTROL QUERY DEFAULT GEN_MAX_NUM_PART_DISK_ENTRIES '3';
CONTROL QUERY DEFAULT GEN_MAX_NUM_PART_NODE_ENTRIES '255';
CONTROL QUERY DEFAULT DYN_QUEUE_RESIZE_FACTOR '4';
CONTROL QUERY DEFAULT DYN_QUEUE_RESIZE_INIT_DOWN '4';
CONTROL QUERY DEFAULT DYN_QUEUE_RESIZE_INIT_UP '4';
CONTROL QUERY DEFAULT DYN_QUEUE_RESIZE_LIMIT '9';
CONTROL QUERY DEFAULT HASH_JOINS 'ON';
CONTROL QUERY DEFAULT HGB_BITMUX 'ON';
CONTROL QUERY DEFAULT HGB_CPUCOST_INITIALIZE '1.';
CONTROL QUERY DEFAULT HGB_DP2_MEMORY_LIMIT '10000.';
CONTROL QUERY DEFAULT HGB_GROUPING_FACTOR_FOR_SPILLED_CLUSTERS '.5';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_BOOLEAN '0.3333';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_IS_NULL '0.01';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_JOIN_EQUAL '0.3333';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_JOIN_RANGE '0.3333';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_LIKE_NO_WILDCARD '1.0';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_LIKE_WILDCARD '0.10';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_PRED_EQUAL '0.01';
CONTROL QUERY DEFAULT HIST_DEFAULT_SEL_FOR_PRED_RANGE '0.3333';
CONTROL QUERY DEFAULT HIST_MAX_NUMBER_OF_INTERVALS '10000';
CONTROL QUERY DEFAULT HIST_MC_STATS_NEEDED 'ON';
CONTROL QUERY DEFAULT HIST_NO_STATS_ROWCOUNT '100';
CONTROL QUERY DEFAULT HIST_NO_STATS_UEC '100';
CONTROL QUERY DEFAULT HIST_NO_STATS_UEC_CHAR1 '10';
CONTROL QUERY DEFAULT HIST_ROWCOUNT_REQUIRING_STATS '50000';
CONTROL QUERY DEFAULT HIST_SAME_TABLE_PRED_REDUCTION '0.0';
CONTROL QUERY DEFAULT DYNAMIC_HISTOGRAM_COMPRESSION 'ON';
CONTROL QUERY DEFAULT HIST_BASE_REDUCTION 'ON';
CONTROL QUERY DEFAULT HIST_INTERMEDIATE_REDUCTION 'OFF';
CONTROL QUERY DEFAULT HIST_BASE_REDUCTION_FUDGE_FACTOR '0.1';
CONTROL QUERY DEFAULT HIST_INTERMEDIATE_REDUCTION_FUDGE_FACTOR '0.25';
CONTROL QUERY DEFAULT HIST_CONSTANT_ALPHA '0.5';
CONTROL QUERY DEFAULT HIST_PREFETCH 'ON';
CONTROL QUERY DEFAULT USTAT_CLUSTER_SAMPLE_BLOCKS '1';
CONTROL QUERY DEFAULT USTAT_FORCE_TEMP 'OFF';
CONTROL QUERY DEFAULT USTAT_LOG 'ULOG';
CONTROL QUERY DEFAULT USTAT_MIN_ESTIMATE_FOR_ROWCOUNT '10000000';
CONTROL QUERY DEFAULT USTAT_MODIFY_DEFAULT_UEC '0.05';
CONTROL QUERY DEFAULT USTAT_UEC_HI_RATIO '0.5';
CONTROL QUERY DEFAULT USTAT_UEC_LOW_RATIO '0.1';
CONTROL QUERY DEFAULT USTAT_USE_SIDETREE_INSERT 'ON';
CONTROL QUERY DEFAULT HH_OP_ALLOCATE_HASH_TABLE '.05';
CONTROL QUERY DEFAULT HH_OP_PROBE_HASH_TABLE '0.011';
CONTROL QUERY DEFAULT HH_OP_INSERT_ROW_TO_CHAIN '0.51';
CONTROL QUERY DEFAULT HH_OP_ALLOCATE_CLUSTERDB '.1';
CONTROL QUERY DEFAULT HH_OP_ALLOCATE_CLUSTER '.1';
CONTROL QUERY DEFAULT HH_OP_ALLOCATE_BUCKET_ARRAY '.1';
CONTROL QUERY DEFAULT HH_OP_READ_HASH_BUFFER '0.';
CONTROL QUERY DEFAULT HH_OP_WRITE_HASH_BUFFER '0.';
CONTROL QUERY DEFAULT HH_OP_HASHED_ROW_OVERHEAD '8.';
CONTROL QUERY DEFAULT HJ_CPUCOST_INITIALIZE '1.';
CONTROL QUERY DEFAULT HJ_BUFFER_SIZE '32';
CONTROL QUERY DEFAULT HJ_INITIAL_BUCKETS_PER_CLUSTER '4.';
CONTROL QUERY DEFAULT HJ_TYPE 'HYBRID';
CONTROL QUERY DEFAULT IMPLICIT_HOSTVAR_CONVERSION 'FALSE';
CONTROL QUERY DEFAULT INDEX_ELIMINATION_LEVEL 'MAXIMUM';
CONTROL QUERY DEFAULT MAT_CREATE_MATERIALIZE_HASH_TABLE '3.1';
CONTROL QUERY DEFAULT MAT_PROBE_MATERIALIZE_HASH_TABLE '35.26';
CONTROL QUERY DEFAULT MATERIALIZE 'SYSTEM';
CONTROL QUERY DEFAULT MERGE_JOIN_CONTROL 'OFF';
CONTROL QUERY DEFAULT MERGE_JOINS 'ON';
CONTROL QUERY DEFAULT MIN_MAX_OPTIMIZATION 'ON';
CONTROL QUERY DEFAULT MJ_CPUCOST_INITIALIZE '1.';
CONTROL QUERY DEFAULT MJ_CPUCOST_ALLOCATE_LIST '.05';
CONTROL QUERY DEFAULT MJ_CPUCOST_INSERT_ROW_TO_LIST '.0001';
CONTROL QUERY DEFAULT MJ_CPUCOST_REWIND_LIST '.01';
CONTROL QUERY DEFAULT MJ_CPUCOST_GET_NEXT_ROW_FROM_LIST '.01';
CONTROL QUERY DEFAULT MJ_CPUCOST_CLEAR_LIST '.01';
CONTROL QUERY DEFAULT MJ_LIST_NODE_SIZE '.01';
CONTROL QUERY DEFAULT MSCF_ET_CPU '0.000014';
CONTROL QUERY DEFAULT MSCF_ET_NM_PAGE_FAULTS '1';
CONTROL QUERY DEFAULT MSCF_ET_NUM_IO_SEEKS '0.0038';
CONTROL QUERY DEFAULT MSCF_ET_IO_TRANSFER '0.00002';
CONTROL QUERY DEFAULT MSCF_ET_NUM_LOCAL_MSGS '0.000125';
CONTROL QUERY DEFAULT MSCF_ET_LOCAL_MSG_TRANSFER '0.000046';
CONTROL QUERY DEFAULT MSCF_ET_NUM_REMOTE_MSGS '0.000125';
CONTROL QUERY DEFAULT MSCF_ET_REMOTE_MSG_TRANSFER '0.00005';
CONTROL QUERY DEFAULT OLT_QUERY_OPT 'ON';
CONTROL QUERY DEFAULT REFERENCE_CPU_FREQUENCY '199.';
CONTROL QUERY DEFAULT REFERENCE_IO_SEQ_READ_RATE '50.0';
CONTROL QUERY DEFAULT REFERENCE_IO_SEEK_TIME '0.0038';
CONTROL QUERY DEFAULT REFERENCE_MSG_LOCAL_RATE '10.';
CONTROL QUERY DEFAULT REFERENCE_MSG_LOCAL_TIME '0.000125';
CONTROL QUERY DEFAULT REFERENCE_MSG_REMOTE_RATE '1.';
CONTROL QUERY DEFAULT REFERENCE_MSG_REMOTE_TIME '0.00125';
CONTROL QUERY DEFAULT REFERENCE_CODE 'RELEASE';
CONTROL QUERY DEFAULT TARGET_CPU_FREQUENCY '199.';
CONTROL QUERY DEFAULT TARGET_IO_SEQ_READ_RATE '50.0';
CONTROL QUERY DEFAULT TARGET_IO_SEEK_TIME '0.0038';
CONTROL QUERY DEFAULT TARGET_MSG_LOCAL_RATE '10.';
CONTROL QUERY DEFAULT TARGET_MSG_LOCAL_TIME '0.000125';
CONTROL QUERY DEFAULT TARGET_MSG_REMOTE_RATE '1.';
CONTROL QUERY DEFAULT TARGET_MSG_REMOTE_TIME '0.00125';
CONTROL QUERY DEFAULT TARGET_CODE 'RELEASE';
CONTROL QUERY DEFAULT MSCF_DEBUG_TO_RELEASE_MULTIPLIER '2.5';
CONTROL QUERY DEFAULT MSCF_OV_IO '0.5';
CONTROL QUERY DEFAULT MSCF_OV_IO_TRANSFER '0.5';
CONTROL QUERY DEFAULT MSCF_OV_LOCAL_MSG_TRANSFER '0.5';
CONTROL QUERY DEFAULT MSCF_OV_MSG '0.5';
CONTROL QUERY DEFAULT MSCF_OV_NUM_IO_SEEKS '0.5';
CONTROL QUERY DEFAULT MSCF_OV_NUM_LOCAL_MSGS '0.5';
CONTROL QUERY DEFAULT MSCF_OV_NUM_REMOTE_MSGS '0.5';
CONTROL QUERY DEFAULT MSCF_OV_REMOTE_MSG_TRANSFER '0.5';
CONTROL QUERY DEFAULT MSCF_CONCURRENCY_IO '0.10';
CONTROL QUERY DEFAULT MSCF_CONCURRENCY_MSG '0.10';
CONTROL QUERY DEFAULT MSCF_SYS_MEMORY_PER_CPU '1';
CONTROL QUERY DEFAULT MSCF_SYS_DISKS '16';
CONTROL QUERY DEFAULT MSCF_SYS_TEMP_SPACE_PER_DISK '50';
CONTROL QUERY DEFAULT MEMORY_UNITS_SIZE '20480';
CONTROL QUERY DEFAULT NUMBER_OF_USERS '1';
CONTROL QUERY DEFAULT MU_CPUCOST_INITIALIZE '.05';
CONTROL QUERY DEFAULT MU_INITIAL_BUFFER_COUNT '5.';
CONTROL QUERY DEFAULT MU_INITIAL_BUFFER_SIZE '1033.7891';
CONTROL QUERY DEFAULT MV_AGE '0';
CONTROL QUERY DEFAULT MV_AS_ROW_TRIGGER 'OFF';
CONTROL QUERY DEFAULT MV_INTERNAL_IGNORE_UNAVAILABLE 'OFF';
CONTROL QUERY DEFAULT MV_REFRESH_MAX_PARALLELISM '0';
CONTROL QUERY DEFAULT MV_REFRESH_MAX_PIPELINING '0';
CONTROL QUERY DEFAULT MV_REWRITE '0';
CONTROL QUERY DEFAULT MV_REWRITE_CANDIDATES '';
CONTROL QUERY DEFAULT MV_TRACE_INCONSISTENCY 'OFF';
CONTROL QUERY DEFAULT NESTED_JOINS 'ON';
CONTROL QUERY DEFAULT NJ_CPUCOST_INITIALIZE '.1';
CONTROL QUERY DEFAULT NJ_CPUCOST_PASS_ROW '.02';
CONTROL QUERY DEFAULT NJ_INITIAL_BUFFER_COUNT '5';
CONTROL QUERY DEFAULT NJ_INITIAL_BUFFER_SIZE '5';
CONTROL QUERY DEFAULT NJ_INC_UPTOLIMIT '0.0225';
CONTROL QUERY DEFAULT NJ_INC_AFTERLIMIT '0.0055';
CONTROL QUERY DEFAULT NJ_INC_MOVEROWS '0.0015';
CONTROL QUERY DEFAULT NJ_MAX_SEEK_DISTANCE '5000';
CONTROL QUERY DEFAULT ODBC_PROCESS 'FALSE';
CONTROL QUERY DEFAULT OPTIMIZATION_GOAL 'LASTROW';
CONTROL QUERY DEFAULT COMPILE_TIME_MONITOR 'OFF';
CONTROL QUERY DEFAULT COMPILE_TIME_MONITOR_OUTPUT_FILE 'NONE';
CONTROL QUERY DEFAULT CACHE_HISTOGRAMS 'ON';
CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL '3600';
CONTROL QUERY DEFAULT HIST_NO_STATS_REFRESH_INTERVAL '3600';
CONTROL QUERY DEFAULT METADATA_CACHE_SIZE '20';
CONTROL QUERY DEFAULT REUSE_BASIC_COST 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_1 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_2 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_3 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_4 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_5 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_6 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_7 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_8 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_9 'OFF';
CONTROL QUERY DEFAULT COMP_INT_1 '0';
CONTROL QUERY DEFAULT COMP_INT_2 '10';
CONTROL QUERY DEFAULT COMP_INT_3 '10';
CONTROL QUERY DEFAULT COMP_INT_4 '400';
CONTROL QUERY DEFAULT COMP_INT_5 '0';
CONTROL QUERY DEFAULT COMP_FLOAT_1 '0.0001';
CONTROL QUERY DEFAULT COMP_FLOAT_2 '0';
CONTROL QUERY DEFAULT COMP_FLOAT_3 '0.01';
CONTROL QUERY DEFAULT COMP_STRING_1 'NONE';
CONTROL QUERY DEFAULT COMP_STRING_2 '';
CONTROL QUERY DEFAULT COMP_STRING_3 '';
CONTROL QUERY DEFAULT QUERY_ANALYSIS 'ON';
CONTROL QUERY DEFAULT DISPLAY_DATA_FLOW_GRAPH 'OFF';
CONTROL QUERY DEFAULT MULTI_JOIN_THRESHOLD '3';
CONTROL QUERY DEFAULT ASM_ALLOWED 'ON';
CONTROL QUERY DEFAULT ASM_PRECOMPUTE 'OFF';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL '3';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_CONSTANT_1 '50';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_CONSTANT_2 '0';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_THRESHOLD '180';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_SAFETY_NET '30000';
CONTROL QUERY DEFAULT OPTIMIZER_HEURISTIC_1 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_HEURISTIC_2 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_HEURISTIC_3 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_HEURISTIC_4 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_HEURISTIC_5 'OFF';
CONTROL QUERY DEFAULT PARALLEL_HEURISTIC_1 'ON';
CONTROL QUERY DEFAULT PARALLEL_HEURISTIC_2 'ON';
CONTROL QUERY DEFAULT PARALLEL_HEURISTIC_3 'ON';
CONTROL QUERY DEFAULT PARALLEL_HEURISTIC_4 'ON';
CONTROL QUERY DEFAULT DATA_FLOW_OPTIMIZATION 'ON';
CONTROL QUERY DEFAULT CROSS_PRODUCT_CONTROL 'ON';
CONTROL QUERY DEFAULT JOIN_ORDER_BY_USER 'OFF';
CONTROL QUERY DEFAULT NESTED_JOIN_CONTROL 'ON';
CONTROL QUERY DEFAULT NESTED_JOIN_FOR_CROSS_PRODUCTS 'ON';
CONTROL QUERY DEFAULT NUM_OF_BLOCKS_PER_ACCESS 'SYSTEM';
CONTROL QUERY DEFAULT SHORT_OPTIMIZATION_PASS_THRESHOLD '12';
CONTROL QUERY DEFAULT PLAN_STEALING 'ON';
CONTROL QUERY DEFAULT PREFERRED_PROBING_ORDER_FOR_NESTED_JOIN 'OFF';
CONTROL QUERY DEFAULT SPEED_STAR_JOIN_COMPILE 'OFF';
CONTROL QUERY DEFAULT TRY_DP2_REPARTITION_ALWAYS 'OFF';
CONTROL QUERY DEFAULT OPTIMIZATION_TASKS_LIMIT '2000000000';
CONTROL QUERY DEFAULT OPTIMIZER_PRUNING 'ON';
CONTROL QUERY DEFAULT OPH_EXITHJCRCONTCHILOOP 'ON';
CONTROL QUERY DEFAULT OPH_EXITMJCRCONTCHILOOP 'ON';
CONTROL QUERY DEFAULT OPH_EXITNJCRCONTCHILOOP 'OFF';
CONTROL QUERY DEFAULT OPH_PRUNING_COMPLEXITY_THRESHOLD '10.0';
CONTROL QUERY DEFAULT OPH_PRUNING_PASS2_COST_LIMIT '-1.0';
CONTROL QUERY DEFAULT OPH_PRUNE_WHEN_COST_LIMIT_EXCEEDED 'OFF';
CONTROL QUERY DEFAULT OPH_USE_NICE_CONTEXT 'OFF';
CONTROL QUERY DEFAULT OPH_REDUCE_COST_LIMIT_FROM_CANDIDATES 'OFF';
CONTROL QUERY DEFAULT OPH_REDUCE_COST_LIMIT_FROM_PASS1_SOLUTION 'ON';
CONTROL QUERY DEFAULT OPH_REUSE_FAILED_PLAN 'ON';
CONTROL QUERY DEFAULT OPH_REUSE_OPERATOR_COST 'OFF';
CONTROL QUERY DEFAULT OPH_SKIP_OGT_FOR_SHARED_GC_FAILED_CL 'OFF';
CONTROL QUERY DEFAULT OPH_USE_CACHED_ELAPSED_TIME 'ON';
CONTROL QUERY DEFAULT OPH_USE_CANDIDATE_PLANS 'OFF';
CONTROL QUERY DEFAULT OPH_USE_COMPARE_COST_THRESHOLD 'ON';
CONTROL QUERY DEFAULT OPH_USE_CONSERVATIVE_COST_LIMIT 'OFF';
CONTROL QUERY DEFAULT OPH_USE_ENFORCER_PLAN_PROMOTION 'OFF';
CONTROL QUERY DEFAULT OPH_USE_FAILED_PLAN_COST 'ON';
CONTROL QUERY DEFAULT OPH_USE_ORDERED_MJ_PRED 'OFF';
CONTROL QUERY DEFAULT OPH_USE_PWS_FLAG_FOR_CONTEXT 'OFF';
CONTROL QUERY DEFAULT PCODE_OPT_LEVEL 'MAXIMUM';
CONTROL QUERY DEFAULT PM_OFFLINE_TRANSACTION_GRANULARITY '5000';
CONTROL QUERY DEFAULT PM_ONLINE_TRANSACTION_GRANULARITY '400';
CONTROL QUERY DEFAULT REDUCTION_TO_PUSH_GB_PAST_TSJ '0.5';
CONTROL QUERY DEFAULT ORDERED_HASH_JOIN_CONTROL 'ON';
CONTROL QUERY DEFAULT OHJ_BMO_REUSE_SORTED_BMOFACTOR_LIMIT '3.0';
CONTROL QUERY DEFAULT OHJ_BMO_REUSE_SORTED_UECRATIO_UPPERLIMIT '0.7';
CONTROL QUERY DEFAULT OHJ_BMO_REUSE_UNSORTED_UECRATIO_UPPERLIMIT '0.01';
CONTROL QUERY DEFAULT OHJ_VBMOLIMIT '5.0';
CONTROL QUERY DEFAULT OR_OPTIMIZATION 'ON';
CONTROL QUERY DEFAULT OPTIMIZER_PRINT_INTERNAL_COUNTERS 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_PRINT_COST 'OFF';
CONTROL QUERY DEFAULT OPTS_PUSH_DOWN_DAM '0';
CONTROL QUERY DEFAULT POS_LOCATIONS '';
CONTROL QUERY DEFAULT POS_NUM_OF_PARTNS 'SYSTEM';
CONTROL QUERY DEFAULT POS_RAISE_ERROR 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE '16384';
CONTROL QUERY DEFAULT QUERY_CACHE_AVERAGE_PLAN_SIZE '30';
CONTROL QUERY DEFAULT QUERY_CACHE_SELECTIVITY_TOLERANCE '0';
CONTROL QUERY DEFAULT QUERY_CACHE_MAX_VICTIMS '10';
CONTROL QUERY DEFAULT QUERY_CACHE_REQUIRED_PREFIX_KEYS '255';
CONTROL QUERY DEFAULT QUERY_CACHE_STATEMENT_PINNING 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE_STATISTICS 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE_STATISTICS_FILE 'qcachsts';
CONTROL QUERY DEFAULT REMOTE_ESP_ALLOCATION 'SYSTEM';
CONTROL QUERY DEFAULT RETURN_AVG_STREAM_WAIT 'OFF';
CONTROL QUERY DEFAULT SAVE_DROPPED_TABLE_DDL 'ON';
CONTROL QUERY DEFAULT SCRATCH_DISKS '';
CONTROL QUERY DEFAULT SCRATCH_DISKS_EXCLUDED '$SYSTEM';
CONTROL QUERY DEFAULT SCRATCH_DISKS_PREFERRED '';
CONTROL QUERY DEFAULT SCRATCH_DRIVE_LETTERS '';
CONTROL QUERY DEFAULT SCRATCH_DRIVE_LETTERS_EXCLUDED '';
CONTROL QUERY DEFAULT SCRATCH_DRIVE_LETTERS_PREFERRED '';
CONTROL QUERY DEFAULT SGB_CPUCOST_INITIALIZE '.05';
CONTROL QUERY DEFAULT SGB_INITIAL_BUFFER_COUNT '5.';
CONTROL QUERY DEFAULT SGB_INITIAL_BUFFER_SIZE '5.';
CONTROL QUERY DEFAULT SORT_CPUCOST_INITIALIZE '10000.';
CONTROL QUERY DEFAULT SORT_QS_FACTOR '1.5';
CONTROL QUERY DEFAULT SORT_RS_FACTOR '3.55';
CONTROL QUERY DEFAULT SORT_IO_BUFFER_SIZE '128.';
CONTROL QUERY DEFAULT SORT_EX_BUFFER_SIZE '5.';
CONTROL QUERY DEFAULT SORT_TREE_NODE_SIZE '.012';
CONTROL QUERY DEFAULT TEMPORARY_TABLE_HASH_PARTITIONS '';
CONTROL QUERY DEFAULT FAKE_VOLUME_ASSIGNMENTS 'OFF';
CONTROL QUERY DEFAULT FAKE_VOLUME_NUM_VOLUMES '24';
CONTROL QUERY DEFAULT ATTEMPT_ASYNCHRONOUS_ACCESS 'ON';
CONTROL QUERY DEFAULT ATTEMPT_ESP_PARALLELISM 'ON';
CONTROL QUERY DEFAULT BASE_NUM_PAS_ON_ACTIVE_PARTS 'OFF';
CONTROL QUERY DEFAULT MAX_ESPS_PER_CPU_PER_OP '1';
CONTROL QUERY DEFAULT MAX_PARTITION_ACCESS_NODES_PER_ESP '1024';
CONTROL QUERY DEFAULT NUMBER_OF_PARTITIONS_DEVIATION '0.25';
CONTROL QUERY DEFAULT NUMBER_OF_ROWS_PARALLEL_THRESHOLD '5000';
CONTROL QUERY DEFAULT NUM_OF_PARTS_DEVIATION_TYPE2_JOINS 'SYSTEM';
CONTROL QUERY DEFAULT PARALLEL_ESP_NODEMASK '0';
CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS 'SYSTEM';
CONTROL QUERY DEFAULT PARTITION_ACCESS_NODES_PER_ESP '1';
CONTROL QUERY DEFAULT UPDATED_BYTES_PER_ESP '400000';
CONTROL QUERY DEFAULT HIDE_INDEXES 'NONE';
CONTROL QUERY DEFAULT UPD_ORDERED 'ON';
CONTROL QUERY DEFAULT IUD_NONAUDITED_INDEX_MAINT 'OFF';
CONTROL QUERY DEFAULT INSERT_VSBB 'SYSTEM';
CONTROL QUERY DEFAULT VSBB_TEST_MODE 'OFF';
CONTROL QUERY DEFAULT DISABLE_BUFFERED_INSERTS 'OFF';
CONTROL QUERY DEFAULT NOT_NULL_CONSTRAINT_DROPPABLE_OPTION 'OFF';
CONTROL QUERY DEFAULT PRIMARY_KEY_CONSTRAINT_DROPPABLE_OPTION 'OFF';
CONTROL QUERY DEFAULT MAX_NUM_VERT_PARTS_FOR_OPT '20';
CONTROL QUERY DEFAULT ISOLATION_LEVEL 'READ_COMMITTED';
CONTROL QUERY DEFAULT IF_LOCKED 'WAIT';
CONTROL QUERY DEFAULT MDAM_CPUCOST_NET_OVH '2000.';
CONTROL QUERY DEFAULT MDAM_CPUCOST_NET_PER_PRED '.5';
CONTROL QUERY DEFAULT MDAM_SCAN_METHOD 'ON';
CONTROL QUERY DEFAULT ACCEPTABLE_INPUTESTLOGPROP_ERROR '0.5';
CONTROL QUERY DEFAULT MDAM_SELECTION_DEFAULT '0.5';
CONTROL QUERY DEFAULT READ_AHEAD_MAX_BLOCKS '16.0';
CONTROL QUERY DEFAULT SIMILARITY_CHECK 'ON';
CONTROL QUERY DEFAULT SYNCDEPTH '1';
CONTROL QUERY DEFAULT TABLELOCK 'SYSTEM';
CONTROL QUERY DEFAULT TIMEOUT '6000';
CONTROL QUERY DEFAULT STREAM_TIMEOUT '-1';
CONTROL QUERY DEFAULT UNAVAILABLE_PARTITION 'STOP';
CONTROL QUERY DEFAULT ZIG_ZAG_TREES 'OFF';
CONTROL QUERY DEFAULT ZIG_ZAG_TREES_CONTROL 'OFF';
CONTROL QUERY DEFAULT RECOMPILATION_WARNINGS 'OFF';
CONTROL QUERY DEFAULT SHOWCONTROL_UNEXTERNALIZED_ATTRS 'OFF';
CONTROL QUERY DEFAULT NAMETYPE 'ANSI';
CONTROL QUERY DEFAULT MP_COLLATIONS '';
CONTROL QUERY DEFAULT NATIONAL_CHARSET 'UCS2';
CONTROL QUERY DEFAULT TERMINAL_CHARSET 'ISO88591';
CONTROL QUERY DEFAULT USE_DENSE_BUFFERS 'ON';
CONTROL QUERY DEFAULT VALIDATE_TIMESTAMP 'ON';
CONTROL QUERY DEFAULT INFER_CHARSET 'OFF';
CONTROL QUERY DEFAULT NSK_DBG 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_LOG_FILE '';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_PARSING 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_BINDING 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_TRANSFORMATION 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_NORMALIZATION 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_ANALYSIS 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_PASS1_PLAN 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_PASS2_PLAN 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_PLAN_LOG 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_PRE_CODEGEN 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_SHOW_TREE_AFTER_CODEGEN 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_COST 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_COST_LIMIT 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_LOG_PROP 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_PHYS_PROP 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_CHAR_INPUT 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_CHAR_OUTPUT 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_CONSTRAINT 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_CONTEXT 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_CONTEXT_POINTER 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_ITEM_EXPR 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_TASK 'OFF';
CONTROL QUERY DEFAULT NSK_DBG_PRINT_TASK_STACK 'OFF';
CONTROL QUERY DEFAULT FORCE_PARALLEL_CREATE_INDEX 'OFF';
CONTROL QUERY DEFAULT UPD_ABORT_ON_ERROR 'OFF';
CONTROL QUERY DEFAULT UPD_PARTIAL_ON_ERROR 'OFF';
CONTROL QUERY DEFAULT UPD_SAVEPOINT_ON_ERROR 'ON';
CONTROL QUERY DEFAULT MAX_ROWS_LOCKED_FOR_STABLE_ACCESS '1';
CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS 'OFF';
CONTROL QUERY DEFAULT UDR_JAVA_OPTION_DELIMITERS ' ';
CONTROL QUERY DEFAULT FSO_RUN_TESTS '0';
CONTROL QUERY DEFAULT FSO_TO_USE '1';
CONTROL QUERY DEFAULT OPTIMIZER_SYNTH_FUNC_DEPENDENCIES 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_10 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_11 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_12 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_13 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_14 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_15 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_16 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_17 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_18 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_19 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_20 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_21 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_22 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_23 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_24 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_25 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_26 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_27 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_28 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_29 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_30 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_31 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_32 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_33 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_34 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_35 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_36 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_37 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_38 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_39 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_40 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_41 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_42 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_43 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_44 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_45 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_46 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_47 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_48 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_49 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_50 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_51 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_52 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_53 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_54 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_55 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_56 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_57 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_58 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_59 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_60 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_61 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_62 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_63 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_64 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_65 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_66 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_67 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_68 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_69 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_70 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_71 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_72 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_73 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_74 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_75 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_76 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_77 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_78 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_79 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_80 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_81 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_82 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_83 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_84 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_85 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_86 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_87 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_88 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_89 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_90 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_91 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_92 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_93 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_94 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_95 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_96 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_97 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_98 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_99 'OFF';
CONTROL QUERY DEFAULT COMP_INT_0 '5000';
CONTROL QUERY DEFAULT COMP_INT_6 '400';
CONTROL QUERY DEFAULT COMP_INT_7 '10000000';
CONTROL QUERY DEFAULT COMP_INT_8 '20';
CONTROL QUERY DEFAULT COMP_INT_9 '0';
CONTROL QUERY DEFAULT COMP_FLOAT_0 '0.01';
CONTROL QUERY DEFAULT COMP_FLOAT_4 '1.5';
CONTROL QUERY DEFAULT COMP_FLOAT_5 '0.25';
CONTROL QUERY DEFAULT COMP_FLOAT_6 '0';
CONTROL QUERY DEFAULT COMP_FLOAT_7 '0';
CONTROL QUERY DEFAULT COMP_FLOAT_8 '16';
CONTROL QUERY DEFAULT COMP_FLOAT_9 '1000000';
CONTROL QUERY DEFAULT COMP_STRING_4 '';
CONTROL QUERY DEFAULT COMP_STRING_5 '';
CONTROL QUERY DEFAULT COSTING_SHORTCUT_GROUPBY_FIX 'ON';
CONTROL QUERY DEFAULT VARCHAR_PARAM_DEFAULT_SIZE '255';
CONTROL QUERY DEFAULT USTAT_MIN_ROWCOUNT_FOR_SAMPLE '10000';
CONTROL QUERY DEFAULT JDBC_PROCESS 'FALSE';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_IMMUNITY_LIMIT '5000';
CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL_1_MJENUM_LIMIT '20';
CONTROL QUERY DEFAULT NSK_DBG_MJRULES_TRACKING 'OFF';
CONTROL QUERY DEFAULT NEW_MDAM 'ON';
CONTROL QUERY DEFAULT REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT 'SYSTEM';
CONTROL QUERY DEFAULT DO_RUNTIME_SPACE_OPTIMIZATION 'OFF';
CONTROL QUERY DEFAULT GEN_SORT_MAX_NUM_BUFFERS '40';
CONTROL QUERY DEFAULT SORT_ITERATIVE_ALGO 'ON';
CONTROL QUERY DEFAULT PM_REGENERATE_SYSKEY_FOR_INSERT 'ON';
CONTROL QUERY DEFAULT ODBC_METADATA_PROCESS 'FALSE';
CONTROL QUERY DEFAULT HIST_JOIN_CARD_LOWBOUND '1.0';
CONTROL QUERY DEFAULT ALLOW_FIRSTN_IN_SUBQUERIES 'FALSE';
CONTROL QUERY DEFAULT USE_CCMPASSERT_AS_CMPASSERT 'OFF';
CONTROL QUERY DEFAULT MXCMP_PLACES_LOCAL_MODULES 'OFF';
CONTROL QUERY DEFAULT SHAREOPENS_ON_REFCOUNT 'ON';
CONTROL QUERY DEFAULT NEW_OPT_DRIVER 'ON';
CONTROL QUERY DEFAULT FORCE_PASS_ONE 'OFF';
CONTROL QUERY DEFAULT FORCE_PASS_TWO 'ON';
CONTROL QUERY DEFAULT TRY_PASS_ONE_IF_PASS_TWO_FAILS 'OFF';
CONTROL QUERY DEFAULT TEST_PASS_ONE_ASSERT_TASK_NUMBER '-1';
CONTROL QUERY DEFAULT TEST_PASS_TWO_ASSERT_TASK_NUMBER '-1';
CONTROL QUERY DEFAULT SHOWWARN_OPT 'ON';
CONTROL QUERY DEFAULT HIST_SCRATCH_VOL '';
CONTROL QUERY DEFAULT PRESERVE_MIN_SCALE '0';
CONTROL QUERY DEFAULT IMPLICIT_DATETIME_INTERVAL_HOSTVAR_CONVERSION 'FALSE';
CONTROL QUERY DEFAULT ATTEMPT_REVERSE_SYNCHRONOUS_ORDER 'ON';
CONTROL QUERY DEFAULT ALLOW_FLOAT_DATATYPES_IN_PARTITIONING_KEY 'FALSE';
CONTROL QUERY DEFAULT SCRATCH_FREESPACE_THRESHOLD_PERCENT '1';
CONTROL QUERY DEFAULT ALLOW_RAND_FUNCTION 'OFF';
CONTROL QUERY DEFAULT HIST_SKIP_MC_FOR_NONKEY_JOIN_COLUMNS 'OFF';
CONTROL QUERY DEFAULT VALIDATE_VIEWS_AT_OPEN_TIME 'OFF';
CONTROL QUERY DEFAULT INTERACTIVE_ACCESS 'OFF';
CONTROL QUERY DEFAULT HIST_SECURITY_WARNINGS 'ON';
CONTROL QUERY DEFAULT DDL_DEFAULT_LOCATIONS '';
CONTROL QUERY DEFAULT QUERY_OPTIMIZATION_OPTIONS '3';
CONTROL QUERY DEFAULT USE_ENVVARS_NAME_MAPPINGS 'OFF';
CONTROL QUERY DEFAULT USTAT_FORCE_MOM_ESTIMATOR 'OFF';
CONTROL QUERY DEFAULT USTAT_DSHMAX '50.0';
CONTROL QUERY DEFAULT EID_SPACE_USAGE_OPT 'OFF';
CONTROL QUERY DEFAULT DO_RUNTIME_EID_SPACE_COMPUTATION 'OFF';
CONTROL QUERY DEFAULT HIST_SCRATCH_VOL_THRESHOLD '104857600';
CONTROL QUERY DEFAULT OVERRIDE_SYSKEY 'OFF';
CONTROL QUERY DEFAULT SORT_RW_FACTOR '2.1';
CONTROL QUERY DEFAULT HIST_MISSING_STATS_WARNING_LEVEL '2';
CONTROL QUERY DEFAULT HIST_DEFAULT_BASE_SEL_FOR_LIKE_WILDCARD '0.50';
CONTROL QUERY DEFAULT DP2_SEQ_READS_WITHOUT_SEEKS '100';
CONTROL QUERY DEFAULT DIMENSIONAL_QUERY_OPTIMIZATION 'OFF';
CONTROL QUERY DEFAULT QUERY_TEMPLATE_CACHE 'ON';
CONTROL QUERY DEFAULT QUERY_TEXT_CACHE 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE_MPALIAS 'OFF';
CONTROL QUERY DEFAULT NOT_ATOMIC_FAILURE_LIMIT 'SYSTEM';
CONTROL QUERY DEFAULT ROWSET_ROW_COUNT 'OFF';
CONTROL QUERY DEFAULT POS_FILE_OPTIONS '';
CONTROL QUERY DEFAULT MAX_DP2_HASHBY_GROUPS '1000';
CONTROL QUERY DEFAULT MAX_HEADER_ENTREIS_PER_HASH_TABLE '250000';
CONTROL QUERY DEFAULT HGB_MAX_TABLE_SIZE_FOR_CLUSTERS '4E5';
CONTROL QUERY DEFAULT HGB_MEMORY_AVAILABLE_FOR_CLUSTERS '10';
CONTROL QUERY DEFAULT HIST_DEFAULT_SAMPLE_MAX '1000000';
CONTROL QUERY DEFAULT HIST_DEFAULT_SAMPLE_RATIO '0.01';
CONTROL QUERY DEFAULT SEQUENTIAL_BLOCKSPLIT 'SYSTEM';
CONTROL QUERY DEFAULT USER_EXPERIENCE_LEVEL 'BEGINNER';
CONTROL QUERY DEFAULT INTERNAL_TESTING_POINT 'OFF';
CONTROL QUERY DEFAULT POS_TABLE_SIZE '';
CONTROL QUERY DEFAULT DYN_PA_QUEUE_RESIZE_INIT_DOWN '4';
CONTROL QUERY DEFAULT DYN_PA_QUEUE_RESIZE_INIT_UP '4';
CONTROL QUERY DEFAULT ALLOW_AUDIT_ATTRIBUTE_CHANGE 'FALSE';
CONTROL QUERY DEFAULT LIMIT_MAX_NUMERIC_PRECISION 'OFF';
CONTROL QUERY DEFAULT CONSTANT_FOLDING 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE_TABLENAME 'OFF';
CONTROL QUERY DEFAULT QUERY_CACHE_RUNTIME 'OFF';
CONTROL QUERY DEFAULT GROUP_BY_USING_ORDINAL 'MINIMUM';
CONTROL QUERY DEFAULT SKIP_UNAVAILABLE_PARTITION 'OFF';
CONTROL QUERY DEFAULT SQLMX_ALIGNED_ROW_FORMAT 'OFF';
CONTROL QUERY DEFAULT ISOLATION_LEVEL_FOR_UPDATES 'NONE';
CONTROL QUERY DEFAULT HIST_LOW_UEC_THRESHOLD '55';
CONTROL QUERY DEFAULT DESTROY_ORDER_AFTER_REPARTITIONING 'OFF';
CONTROL QUERY DEFAULT MERGE_JOIN_WITH_POSSIBLE_DEADLOCK 'OFF';
CONTROL QUERY DEFAULT DP2_PRIORITY '-1001';
CONTROL QUERY DEFAULT DP2_PRIORITY_DELTA '-1001';
CONTROL QUERY DEFAULT ALLOW_RANGE_PARTITIONING 'TRUE';
CONTROL QUERY DEFAULT SORT_MAX_HEAP_SIZE_MB '170';
CONTROL QUERY DEFAULT EXPAND_DP2_SHORT_ROWS 'ON';
CONTROL QUERY DEFAULT MVGROUP_AUTOMATIC_CREATION 'ON';
CONTROL QUERY DEFAULT POS_MAP_HASH_TO_HASH2 'ON';
CONTROL QUERY DEFAULT SOFT_REQ_HASH_TYPE '2';
CONTROL QUERY DEFAULT OLD_HASH2_GROUPING 'FALSE';
CONTROL QUERY DEFAULT MAINTAIN_UPD_STATS_SAMPLE '-1';
CONTROL QUERY DEFAULT COMP_INT_10 '3';
CONTROL QUERY DEFAULT COMP_INT_11 '0';
CONTROL QUERY DEFAULT COMP_INT_12 '0';
CONTROL QUERY DEFAULT COMP_INT_13 '0';
CONTROL QUERY DEFAULT COMP_INT_14 '0';
CONTROL QUERY DEFAULT COMP_INT_15 '7';
CONTROL QUERY DEFAULT COMP_INT_16 '1000000';
CONTROL QUERY DEFAULT COMP_INT_17 '1000000';
CONTROL QUERY DEFAULT COMP_INT_18 '3';
CONTROL QUERY DEFAULT COMP_INT_19 '2';
CONTROL QUERY DEFAULT COMP_INT_20 '4';
CONTROL QUERY DEFAULT COMP_INT_21 '0';
CONTROL QUERY DEFAULT COMP_INT_22 '100';
CONTROL QUERY DEFAULT COMP_INT_23 '22';
CONTROL QUERY DEFAULT COMP_INT_24 '0';
CONTROL QUERY DEFAULT COMP_INT_25 '0';
CONTROL QUERY DEFAULT COMP_INT_26 '0';
CONTROL QUERY DEFAULT COMP_INT_27 '0';
CONTROL QUERY DEFAULT COMP_INT_28 '0';
CONTROL QUERY DEFAULT COMP_INT_29 '0';
CONTROL QUERY DEFAULT COMP_INT_30 '2';
CONTROL QUERY DEFAULT COMP_INT_31 '2';
CONTROL QUERY DEFAULT COMP_INT_32 '10000';
CONTROL QUERY DEFAULT COMP_INT_33 '0';
CONTROL QUERY DEFAULT COMP_INT_34 '0';
CONTROL QUERY DEFAULT COMP_INT_35 '0';
CONTROL QUERY DEFAULT COMP_INT_36 '0';
CONTROL QUERY DEFAULT COMP_INT_37 '0';
CONTROL QUERY DEFAULT COMP_INT_38 '0';
CONTROL QUERY DEFAULT COMP_INT_39 '0';
CONTROL QUERY DEFAULT COMP_INT_40 '0';
CONTROL QUERY DEFAULT COMP_INT_41 '0';
CONTROL QUERY DEFAULT COMP_INT_42 '0';
CONTROL QUERY DEFAULT COMP_INT_43 '0';
CONTROL QUERY DEFAULT COMP_INT_44 '0';
CONTROL QUERY DEFAULT COMP_INT_45 '0';
CONTROL QUERY DEFAULT COMP_INT_46 '0';
CONTROL QUERY DEFAULT COMP_INT_47 '0';
CONTROL QUERY DEFAULT COMP_INT_48 '0';
CONTROL QUERY DEFAULT COMP_INT_49 '0';
CONTROL QUERY DEFAULT COMP_INT_50 '0';
CONTROL QUERY DEFAULT COMP_INT_51 '0';
CONTROL QUERY DEFAULT COMP_INT_52 '0';
CONTROL QUERY DEFAULT COMP_INT_53 '0';
CONTROL QUERY DEFAULT COMP_INT_54 '0';
CONTROL QUERY DEFAULT COMP_INT_55 '0';
CONTROL QUERY DEFAULT COMP_INT_56 '0';
CONTROL QUERY DEFAULT COMP_INT_57 '0';
CONTROL QUERY DEFAULT COMP_INT_58 '0';
CONTROL QUERY DEFAULT COMP_INT_59 '0';
CONTROL QUERY DEFAULT COMP_INT_60 '0';
CONTROL QUERY DEFAULT COMP_INT_61 '0';
CONTROL QUERY DEFAULT COMP_INT_62 '0';
CONTROL QUERY DEFAULT COMP_INT_63 '0';
CONTROL QUERY DEFAULT COMP_INT_64 '0';
CONTROL QUERY DEFAULT COMP_INT_65 '0';
CONTROL QUERY DEFAULT COMP_INT_66 '0';
CONTROL QUERY DEFAULT COMP_INT_67 '0';
CONTROL QUERY DEFAULT COMP_INT_68 '0';
CONTROL QUERY DEFAULT COMP_INT_69 '0';
CONTROL QUERY DEFAULT COMP_INT_70 '1000000';
CONTROL QUERY DEFAULT COMP_INT_71 '0';
CONTROL QUERY DEFAULT COMP_INT_72 '0';
CONTROL QUERY DEFAULT COMP_INT_73 '0';
CONTROL QUERY DEFAULT COMP_INT_74 '0';
CONTROL QUERY DEFAULT COMP_INT_75 '0';
CONTROL QUERY DEFAULT COMP_INT_76 '0';
CONTROL QUERY DEFAULT COMP_INT_77 '0';
CONTROL QUERY DEFAULT COMP_INT_78 '0';
CONTROL QUERY DEFAULT COMP_INT_79 '0';
CONTROL QUERY DEFAULT COMP_INT_80 '0';
CONTROL QUERY DEFAULT COMP_INT_81 '0';
CONTROL QUERY DEFAULT COMP_INT_82 '0';
CONTROL QUERY DEFAULT COMP_INT_83 '0';
CONTROL QUERY DEFAULT COMP_INT_84 '0';
CONTROL QUERY DEFAULT COMP_INT_85 '0';
CONTROL QUERY DEFAULT COMP_INT_86 '0';
CONTROL QUERY DEFAULT COMP_INT_87 '0';
CONTROL QUERY DEFAULT COMP_INT_88 '0';
CONTROL QUERY DEFAULT COMP_INT_89 '0';
CONTROL QUERY DEFAULT COMP_INT_90 '1';
CONTROL QUERY DEFAULT COMP_INT_91 '0';
CONTROL QUERY DEFAULT COMP_INT_92 '0';
CONTROL QUERY DEFAULT COMP_INT_93 '0';
CONTROL QUERY DEFAULT COMP_INT_94 '0';
CONTROL QUERY DEFAULT COMP_INT_95 '0';
CONTROL QUERY DEFAULT COMP_INT_96 '0';
CONTROL QUERY DEFAULT COMP_INT_97 '0';
CONTROL QUERY DEFAULT COMP_INT_98 '0';
CONTROL QUERY DEFAULT COMP_INT_99 '0';
CONTROL QUERY DEFAULT COMP_BOOL_100 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_101 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_102 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_103 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_104 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_105 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_106 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_107 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_108 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_109 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_110 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_111 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_112 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_113 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_114 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_115 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_116 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_117 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_118 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_119 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_120 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_121 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_122 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_123 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_124 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_125 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_126 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_127 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_128 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_129 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_130 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_131 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_132 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_133 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_134 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_135 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_136 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_137 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_138 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_139 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_140 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_141 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_142 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_143 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_144 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_145 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_146 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_147 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_148 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_149 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_150 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_151 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_152 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_153 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_154 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_155 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_156 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_157 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_158 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_159 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_160 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_161 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_162 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_163 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_164 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_165 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_166 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_167 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_168 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_169 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_170 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_171 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_172 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_173 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_174 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_175 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_176 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_177 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_178 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_179 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_180 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_181 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_182 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_183 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_184 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_185 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_186 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_187 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_188 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_189 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_190 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_191 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_192 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_193 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_194 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_195 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_196 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_197 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_198 'OFF';
CONTROL QUERY DEFAULT COMP_BOOL_199 'OFF';
CONTROL QUERY DEFAULT HIST_OPTIMISTIC_CARD_OPTIMIZATION '0';
CONTROL QUERY DEFAULT MAINTAIN_REORG_PRIORITY '-1';
CONTROL QUERY DEFAULT MAINTAIN_REORG_PRIORITY_DELTA '0';
CONTROL QUERY DEFAULT MAINTAIN_REORG_RATE '40';
CONTROL QUERY DEFAULT MAINTAIN_REORG_SLACK '0';
CONTROL QUERY DEFAULT IDENTITY_USER_DUPLICATE_VALUE 'OFF';
CONTROL QUERY DEFAULT IDENTITY_MASK_BITS '16';
CONTROL QUERY DEFAULT GEN_SID_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_SID_NUM_BUFFERS '4';
CONTROL QUERY DEFAULT CAT_UPDATE_METADATA 'OFF';
CONTROL QUERY DEFAULT GEN_HGBY_PARTIAL_GROUP_FLUSH_THRESHOLD '100';
CONTROL QUERY DEFAULT GEN_HGBY_PARTIAL_GROUP_ROWS_PER_CLUSTER '0';
CONTROL QUERY DEFAULT GEN_HGBY_MIN_ESTIMATED_ROW_COUNT '100000';
CONTROL QUERY DEFAULT SQLMX_UTIL_EXPLAIN_PLAN 'OFF';
CONTROL QUERY DEFAULT SQLMX_TEST_POINT 'OFF';
CONTROL QUERY DEFAULT GEN_IAR_BUFFER_SIZE '10240';
CONTROL QUERY DEFAULT GEN_IAR_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_IAR_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_IAR_SIZE_UP '4';
CONTROL QUERY DEFAULT AUDIT_IMAGE_FOR_TABLES 'OFF';
CONTROL QUERY DEFAULT ALLOW_DP2_ROW_SAMPLING 'SYSTEM';
CONTROL QUERY DEFAULT POS_ALLOW_NON_PK_TABLES 'OFF';
CONTROL QUERY DEFAULT INCORPORATE_SKEW_IN_COSTING 'OFF';
CONTROL QUERY DEFAULT TOTAL_RESOURCE_COSTING 'ON';
CONTROL QUERY DEFAULT GEN_PAR_LAB_OP_NUM_BUFFERS '1';
CONTROL QUERY DEFAULT GEN_PAR_LAB_OP_BUFFER_SIZE '1024';
CONTROL QUERY DEFAULT GEN_PAR_LAB_OP_SIZE_DOWN '2';
CONTROL QUERY DEFAULT GEN_PAR_LAB_OP_SIZE_UP '4';
CONTROL QUERY DEFAULT USE_PARALLEL_FOR_NUM_PARTITIONS '32';
CONTROL QUERY DEFAULT CREATE_FOR_NO_RDF_REPLICATE 'OFF';
CONTROL QUERY DEFAULT CREATE_DEFINITION_SCHEMA_VERSION '0';
CONTROL QUERY DEFAULT EXE_DIAGNOSTIC_EVENTS 'OFF';
CONTROL QUERY DEFAULT SHARE_TEMPLATE_CACHED_PLANS 'ON';
CONTROL QUERY DEFAULT MODE_SPECIAL_1 'OFF';
CONTROL QUERY DEFAULT SESSION_IN_USE 'OFF';
CONTROL QUERY DEFAULT VOLATILE_SCHEMA_IN_USE 'OFF';
CONTROL QUERY DEFAULT VOLATILE_CATALOG '';
CONTROL QUERY DEFAULT LAST0_MODE 'OFF';
CONTROL QUERY DEFAULT OUTPUT_DATE_FORMAT '';
CONTROL QUERY DEFAULT IMPLICIT_UPD_STATS_THRESHOLD '-1';
CONTROL QUERY DEFAULT POS_NUM_OF_TEMP_TABLE_PARTNS 'SYSTEM';
CONTROL QUERY DEFAULT POS_TEMP_TABLE_LOCATIONS '';
CONTROL QUERY DEFAULT POS_TEMP_TABLE_SIZE '';
CONTROL QUERY DEFAULT HIST_DEFAULT_NUMBER_OF_INTERVALS '200';
CONTROL QUERY DEFAULT IGNORE_DUPLICATE_KEYS 'SYSTEM';
CONTROL QUERY DEFAULT SESSION_USERNAME '';
CONTROL QUERY DEFAULT DP2_CACHE_8K_BLOCKS '2048';
CONTROL QUERY DEFAULT DP2_CACHE_16K_BLOCKS '1024';
CONTROL QUERY DEFAULT DP2_CACHE_32K_BLOCKS '512';
CONTROL QUERY DEFAULT CAT_LARGE_BLOCKS_LARGE_KEYS 'ON';
CONTROL QUERY DEFAULT GEN_DBLIMITS_LARGER_BUFSIZE 'ON';
CONTROL QUERY DEFAULT CAT_LARGE_BLOCKS_MAX_KEYSIZE '1';
CONTROL QUERY DEFAULT CAT_LARGE_BLOCKS_MAX_ROWSIZE '1';
CONTROL QUERY DEFAULT ALIGNED_ROW_FORMAT 'OFF';
CONTROL QUERY DEFAULT SQLMX_SHOWDDL_SUPPRESS_ROW_FORMAT 'OFF';
CONTROL QUERY DEFAULT FORCE_PARALLEL_INSERT_SELECT 'OFF';
CONTROL QUERY DEFAULT GEN_UDRRS_BUFFER_SIZE '31000';
CONTROL QUERY DEFAULT GEN_UDRRS_NUM_BUFFERS '2';
CONTROL QUERY DEFAULT GEN_UDRRS_SIZE_DOWN '4';
CONTROL QUERY DEFAULT GEN_UDRRS_SIZE_UP '128';
CONTROL QUERY DEFAULT FAST_DELETE 'OFF';
CONTROL QUERY DEFAULT ALLOW_UNEXTERNALIZED_MAINTAIN_OPTIONS 'OFF';
CONTROL QUERY DEFAULT OPI_ERROR73_RETRIES '10';
CONTROL QUERY DEFAULT EXE_MEMORY_AVAILABLE_IN_MB '1200';
CONTROL QUERY DEFAULT CAT_FS_TIMEOUT '9000';
CONTROL QUERY DEFAULT METADATA_STABLE_ACCESS 'OFF';
CONTROL QUERY DEFAULT NAR_DEPOBJ_ENABLE 'ON';
CONTROL QUERY DEFAULT AFFINITY_VALUE '-1';
CONTROL QUERY DEFAULT CYCLIC_ESP_PLACEMENT 'OFF';
CONTROL QUERY DEFAULT DEFAULT_DEGREE_OF_PARALLELISM '32';
CONTROL QUERY DEFAULT NSK_DBG_GENERIC 'OFF';
CONTROL QUERY DEFAULT MEMORY_UNIT_ESP '300';
CONTROL QUERY DEFAULT WORK_UNIT_ESP '1';
CONTROL QUERY DEFAULT WORK_UNIT_ESP_DATA_COPY_COST '0.01';
CONTROL QUERY DEFAULT DISTRIBUTE_OPENS '0';
CONTROL QUERY DEFAULT MV_REFRESH_MDELTA_MAX_DELTAS_THRESHOLD '31';
CONTROL QUERY DEFAULT MV_REFRESH_MDELTA_MAX_JOIN_SIZE_FOR_SINGLE_PHASE '3';
CONTROL QUERY DEFAULT MV_REFRESH_MDELTA_MIN_JOIN_SIZE_FOR_SINGLE_PRODUCT_PHASE '8';
CONTROL QUERY DEFAULT MV_REFRESH_MDELTA_PHASE_SIZE_FOR_MID_RANGE '6';
CONTROL QUERY DEFAULT MJ_OVERFLOW 'ON';
CONTROL QUERY DEFAULT SKEW_EXPLAIN 'OFF';
CONTROL QUERY DEFAULT SKEW_ROWCOUNT_THRESHOLD '1000000';
CONTROL QUERY DEFAULT MJ_BMO_QUOTA_PERCENT '0';
CONTROL QUERY DEFAULT SKEW_SENSITIVITY_THRESHOLD '-1';
CONTROL QUERY DEFAULT USTAT_INTERNAL_SORT 'HYBRID';
CONTROL QUERY DEFAULT USTAT_IS_MEMORY_FRACTION '0.6';
CONTROL QUERY DEFAULT MAX_SKEW_VALUES_DETECTED '10000';
CONTROL QUERY DEFAULT CREATE_OBJECTS_IN_METADATA_ONLY 'OFF';
CONTROL QUERY DEFAULT OSIM_MXEXPORTDDL_LOC '/usr/tandem/sqlmx/bin';
CONTROL QUERY DEFAULT OSIM_SIMULATION_LOC 'NONE';
CONTROL QUERY DEFAULT DO_MINIMAL_RENAME 'OFF';
CONTROL QUERY DEFAULT SORT_MEMORY_QUOTA_SYSTEM 'ON';
CONTROL QUERY DEFAULT ROUNDING_MODE '0';
CONTROL QUERY DEFAULT REUSE_OPENS 'OFF';
CONTROL QUERY DEFAULT ALTPRI_MASTER 'FALSE';
CONTROL QUERY DEFAULT IGNORE_TRIGGERS 'FALSE';
CONTROL QUERY DEFAULT BLOCK_TO_PREVENT_HALLOWEEN 'OFF';
CONTROL QUERY DEFAULT R2_HALLOWEEN_SUPPORT 'OFF';
CONTROL QUERY DEFAULT HIST_ASSUME_INDEPENDENT_REDUCTION 'ON';
