Set up script
CREATE TABLE infl1 (
id NUMBER NOT NULL,
name VARCHAR2(30) NOT NULL,
payload VARCHAR2(200),
CONSTRAINT infl1_pk PRIMARY KEY (id)
);
CREATE TABLE infl2 (
id NUMBER NOT NULL,
name VARCHAR2(30) NOT NULL,
payload VARCHAR2(200),
CONSTRAINT infl2_pk PRIMARY KEY (id)
);
CREATE TABLE infl3 (
id NUMBER NOT NULL,
name VARCHAR2(30) NOT NULL,
payload VARCHAR2(200),
CONSTRAINT infl3_pk PRIMARY KEY (id)
);
INSERT INTO infl1
WITH num_sets AS ( SELECT rownum AS set_num FROM all_objects WHERE rownum <= 10 )
SELECT 1000000 * set_num + b.object_id, b.object_name, RPAD(b.object_name, 200)
FROM num_sets a CROSS
JOIN all_objects b;
INSERT INTO infl2
WITH num_sets AS ( SELECT rownum AS set_num FROM all_objects WHERE rownum <= 10 )
SELECT 1000000 * set_num + 2 * b.object_id, b.object_name, RPAD(b.object_name, 200)
FROM num_sets a CROSS
JOIN all_objects b;
INSERT INTO infl3
WITH num_sets AS ( SELECT rownum AS set_num FROM all_objects WHERE rownum <= 10 )
SELECT 1000000 * set_num + 3 * b.object_id, b.object_name, RPAD(b.object_name, 200)
FROM num_sets a CROSS
JOIN all_objects b;
COMMIT;
exec DBMS_STATS.gather_table_stats(user, 'infl1');
exec DBMS_STATS.gather_table_stats(user, 'infl2');
exec DBMS_STATS.gather_table_stats(user, 'infl3');
SELECT /*+ gather_plan_statistics */ count(*) "Count"
FROM infl1 a
JOIN infl2 b USING (id)
JOIN infl3 c USING (id);
SELECT * FROM table(DBMS_XPLAN.display_cursor(format => '+adaptive, allstats last'));
|
Adaptive plan example:
Count
----------
109810
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID axtyp508s9xjy, child number 0
-------------------------------------
SELECT /*+ gather_plan_statistics */ count(*) "Count" FROM infl1 a
JOIN infl2 b USING (id) JOIN infl3 c USING (id)
Plan hash value: 2309129149
---------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem | Used-Tmp|
---------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:20.99 | 9843 | | | | |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:20.99 | 9843 | | | | |
| * 2 | HASH JOIN | | 1 | 846K| 109K|00:00:20.85 | 9843 | 37M| 5779K| 41M (0)| |
| 3 | INDEX FAST FULL SCAN | INFL3_PK | 1 | 846K| 846K|00:00:01.11 | 3281 | | | | |
| * 4 | HASH JOIN | | 1 | 846K| 381K|00:00:14.31 | 6562 | 39M| 5248K| 42M (0)| |
|- 5 | NESTED LOOPS | | 1 | 846K| 846K|00:00:05.39 | 3281 | | | | |
|- 6 | STATISTICS COLLECTOR | | 1 | | 846K|00:00:03.29 | 3281 | | | | |
| 7 | INDEX FAST FULL SCAN| INFL1_PK | 1 | 846K| 846K|00:00:01.16 | 3281 | | | | |
|- * 8 | INDEX UNIQUE SCAN | INFL2_PK | 0 | 1 | 0 |00:00:00.01 | 0 | | | | |
| 9 | INDEX FAST FULL SCAN | INFL2_PK | 1 | 846K| 846K|00:00:01.15 | 3281 | | | | |
---------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("B"."ID"="C"."ID")
4 - access("A"."ID"="B"."ID")
8 - access("A"."ID"="B"."ID")
Note
-----
- this is an adaptive plan (rows marked '-' are inactive)
|
Tradition plan for the same query:
EXPLAIN PLAN FOR
SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id);
SELECT * FROM table(DBMS_XPLAN.display());
|
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------
Plan hash value: 2309129149
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 18 | | 5771 (1)| 00:00:01 |
| 1 | SORT AGGREGATE | | 1 | 18 | | | |
|* 2 | HASH JOIN | | 846K| 14M| 14M| 5771 (1)| 00:00:01 |
| 3 | INDEX FAST FULL SCAN | INFL3_PK | 846K| 4959K| | 875 (1)| 00:00:01 |
|* 4 | HASH JOIN | | 846K| 9919K| 14M| 3208 (1)| 00:00:01 |
| 5 | INDEX FAST FULL SCAN| INFL1_PK | 846K| 4959K| | 875 (1)| 00:00:01 |
| 6 | INDEX FAST FULL SCAN| INFL2_PK | 846K| 4959K| | 885 (1)| 00:00:01 |
--------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("INFL2"."ID"="INFL3"."ID")
4 - access("INFL1"."ID"="INFL2"."ID")
Note
-----
- this is an adaptive plan
|
10053 trace for the above plan:
ALTER SESSION SET EVENTS '10053 trace name context forever, level 1';
SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id);
|
The unabrieviated trace file is below, note the amount of iterative work done to identify the inflection point (search for the word "inflection" and keep pressing refind)
Trace file /app/oracle/app/diag/rdbms/ora12c/ora12c/trace/ora12c_ora_9494.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /app/oracle/app/product/12.1.0/dbhome_1
System name: Linux
Node name: centos6
Release: 2.6.32-358.18.1.el6.x86_64
Version: #1 SMP Wed Aug 28 17:19:38 UTC 2013
Machine: x86_64
Instance name: ora12c
Redo thread mounted by this instance: 1
Oracle process number: 7
Unix process pid: 9494, image: oracle@centos6
*** 2013-10-15 15:00:04.696
*** SESSION ID:(279.541) 2013-10-15 15:00:04.696
*** CLIENT ID:() 2013-10-15 15:00:04.696
*** SERVICE NAME:(plugdb) 2013-10-15 15:00:04.696
*** MODULE NAME:(SQL*Plus) 2013-10-15 15:00:04.696
*** ACTION NAME:() 2013-10-15 15:00:04.696
*** CONTAINER ID:(3) 2013-10-15 15:00:04.696
Registered qb: SEL$1 0x719d7828 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$1 nbfros=2 flg=0
fro(0): flg=4 objn=92455 hint_alias="INFL1"@"SEL$1"
fro(1): flg=4 objn=92457 hint_alias="INFL2"@"SEL$1"
Registered qb: SEL$2 0x719d2790 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$2 nbfros=2 flg=0
fro(0): flg=4 objn=92459 hint_alias="INFL3"@"SEL$2"
fro(1): flg=5 objn=0 hint_alias="from$_subquery$_003"@"SEL$2"
Registered qb: SEL$3 0x719def80 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$3 nbfros=1 flg=0
fro(0): flg=5 objn=0 hint_alias="from$_subquery$_005"@"SEL$3"
SPM: statement not found in SMB
SPM: capture of plan baseline is OFF
**************************
Automatic degree of parallelism (AUTODOP)
**************************
Automatic degree of parallelism is disabled: Parameter.
PM: Considering predicate move-around in query block SEL$3 (#0)
**************************
Predicate Move-Around (PM)
**************************
OPTIMIZER INFORMATION
******************************************
*** 2013-10-15 15:00:04.946
----- Current SQL Statement for this session (sql_id=1vnadspvk62bn) -----
SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id)
*******************************************
Legend
The following abbreviations are used by optimizer trace.
CBQT - cost-based query transformation
JPPD - join predicate push-down
OJPPD - old-style (non-cost-based) JPPD
FPD - filter push-down
PM - predicate move-around
CVM - complex view merging
SPJ - select-project-join
SJC - set join conversion
SU - subquery unnesting
OBYE - order by elimination
OST - old style star transformation
ST - new (cbqt) star transformation
CNT - count(col) to count(*) transformation
JE - Join Elimination
JF - join factorization
SLP - select list pruning
DP - distinct placement
qb - query block
LB - leaf blocks
DK - distinct keys
LB/K - average number of leaf blocks per key
DB/K - average number of data blocks per key
CLUF - clustering factor
NDV - number of distinct values
Resp - response cost
Card - cardinality
Resc - resource cost
NL - nested loops (join)
SM - sort merge (join)
HA - hash (join)
CPUSPEED - CPU Speed
IOTFRSPEED - I/O transfer speed
IOSEEKTIM - I/O seek time
SREADTIM - average single block read time
MREADTIM - average multiblock read time
MBRC - average multiblock read count
MAXTHR - maximum I/O system throughput
SLAVETHR - average slave I/O throughput
dmeth - distribution method
1: no partitioning required
2: value partitioned
4: right is random (round-robin)
128: left is random (round-robin)
8: broadcast right and partition left
16: broadcast left and partition right
32: partition left using partitioning of right
64: partition right using partitioning of left
256: run the join in serial
0: invalid distribution method
sel - selectivity
ptn - partition
AP - adaptive plans
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
*************************************
PARAMETERS WITH ALTERED VALUES
******************************
Compilation Environment Dump
sqlstat_enabled = true
statistics_level = all
Bug Fix Control Environment
*************************************
PARAMETERS WITH DEFAULT VALUES
******************************
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 12.1.0.1
_optimizer_search_limit = 5
cpu_count = 2
active_instance_count = 1
parallel_threads_per_cpu = 2
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 274432 KB
_pga_max_size = 204800 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 274 KB
_smm_max_size_static = 54886 KB
_smm_px_max_size_static = 137216 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 12.1.0.1
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
_optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 80
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 66
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 4
total_cpu_count = 2
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 126
_px_cpu_autodop_enabled = true
parallel_degree_level = 100
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_adaptive_plans = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 200
_use_hidden_partitions = false
_px_monitor_load = false
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 1
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = false
optimizer_adaptive_features = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 3
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_array_cdb_view_enabled = true
Bug Fix Control Environment
fix 3834770 = 1
fix 3746511 = enabled
fix 4519016 = enabled
fix 3118776 = enabled
fix 4488689 = enabled
fix 2194204 = disabled
fix 2660592 = enabled
fix 2320291 = enabled
fix 2324795 = enabled
fix 4308414 = enabled
fix 3499674 = disabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 1403283 = enabled
fix 4554846 = enabled
fix 4602374 = enabled
fix 4584065 = enabled
fix 4545833 = enabled
fix 4611850 = enabled
fix 4663698 = enabled
fix 4663804 = enabled
fix 4666174 = enabled
fix 4567767 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4708389 = enabled
fix 4175830 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 4386734 = enabled
fix 4887636 = enabled
fix 4483240 = enabled
fix 4872602 = disabled
fix 4711525 = enabled
fix 4545802 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 4900129 = enabled
fix 4924149 = enabled
fix 4663702 = enabled
fix 4878299 = enabled
fix 4658342 = enabled
fix 4881533 = enabled
fix 4676955 = enabled
fix 4273361 = enabled
fix 4967068 = enabled
fix 4969880 = disabled
fix 5005866 = enabled
fix 5015557 = enabled
fix 4705343 = enabled
fix 4904838 = enabled
fix 4716096 = enabled
fix 4483286 = disabled
fix 4722900 = enabled
fix 4615392 = enabled
fix 5096560 = enabled
fix 5029464 = enabled
fix 4134994 = enabled
fix 4904890 = enabled
fix 5104624 = enabled
fix 5014836 = enabled
fix 4768040 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 4595987 = enabled
fix 4908162 = enabled
fix 5139520 = enabled
fix 5084239 = enabled
fix 5143477 = disabled
fix 2663857 = enabled
fix 4717546 = enabled
fix 5240264 = disabled
fix 5099909 = enabled
fix 5240607 = enabled
fix 5195882 = enabled
fix 5220356 = enabled
fix 5263572 = enabled
fix 5385629 = enabled
fix 5302124 = enabled
fix 5391942 = enabled
fix 5384335 = enabled
fix 5482831 = enabled
fix 4158812 = enabled
fix 5387148 = enabled
fix 5383891 = enabled
fix 5466973 = enabled
fix 5396162 = enabled
fix 5394888 = enabled
fix 5395291 = enabled
fix 5236908 = enabled
fix 5509293 = enabled
fix 5449488 = enabled
fix 5567933 = enabled
fix 5570494 = enabled
fix 5288623 = enabled
fix 5505995 = enabled
fix 5505157 = enabled
fix 5112460 = enabled
fix 5554865 = enabled
fix 5112260 = enabled
fix 5112352 = enabled
fix 5547058 = enabled
fix 5618040 = enabled
fix 5585313 = enabled
fix 5547895 = enabled
fix 5634346 = enabled
fix 5620485 = enabled
fix 5483301 = enabled
fix 5657044 = enabled
fix 5694984 = enabled
fix 5868490 = enabled
fix 5650477 = enabled
fix 5611962 = enabled
fix 4279274 = enabled
fix 5741121 = enabled
fix 5714944 = enabled
fix 5391505 = enabled
fix 5762598 = enabled
fix 5578791 = enabled
fix 5259048 = enabled
fix 5882954 = enabled
fix 2492766 = enabled
fix 5707608 = enabled
fix 5891471 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5371452 = enabled
fix 5838613 = enabled
fix 5949981 = enabled
fix 5624216 = enabled
fix 5741044 = enabled
fix 5976822 = enabled
fix 6006457 = enabled
fix 5872956 = enabled
fix 5923644 = enabled
fix 5943234 = enabled
fix 5844495 = enabled
fix 4168080 = enabled
fix 6020579 = enabled
fix 5842686 = disabled
fix 5996801 = enabled
fix 5593639 = enabled
fix 6133948 = enabled
fix 3151991 = enabled
fix 6146906 = enabled
fix 6239909 = enabled
fix 6267621 = enabled
fix 5909305 = enabled
fix 6279918 = enabled
fix 6141818 = enabled
fix 6151963 = enabled
fix 6251917 = enabled
fix 6282093 = enabled
fix 6119510 = enabled
fix 6119382 = enabled
fix 3801750 = enabled
fix 5705630 = disabled
fix 5944076 = enabled
fix 5406763 = enabled
fix 6070954 = enabled
fix 6282944 = enabled
fix 6138746 = enabled
fix 6082745 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 6062266 = enabled
fix 6087237 = enabled
fix 6122894 = enabled
fix 6377505 = enabled
fix 5893768 = enabled
fix 6163564 = enabled
fix 6073325 = enabled
fix 6188881 = enabled
fix 6007259 = enabled
fix 6239971 = enabled
fix 5284200 = disabled
fix 6042205 = enabled
fix 6051211 = enabled
fix 6434668 = enabled
fix 6438752 = enabled
fix 5936366 = enabled
fix 6439032 = enabled
fix 6438892 = enabled
fix 6006300 = enabled
fix 5947231 = enabled
fix 5416118 = 1
fix 6365442 = 1
fix 6239039 = enabled
fix 6502845 = enabled
fix 6913094 = enabled
fix 6029469 = enabled
fix 5919513 = enabled
fix 6057611 = enabled
fix 6469667 = enabled
fix 6608941 = disabled
fix 6368066 = enabled
fix 6329318 = enabled
fix 6656356 = enabled
fix 4507997 = enabled
fix 6671155 = enabled
fix 6694548 = enabled
fix 6688200 = enabled
fix 6612471 = enabled
fix 6708183 = disabled
fix 6326934 = enabled
fix 6520717 = disabled
fix 6714199 = enabled
fix 6681545 = enabled
fix 6748058 = enabled
fix 6167716 = enabled
fix 6674254 = enabled
fix 6468287 = enabled
fix 6503543 = enabled
fix 6808773 = disabled
fix 6766962 = enabled
fix 6120483 = enabled
fix 6670551 = enabled
fix 6771838 = enabled
fix 6626018 = disabled
fix 6530596 = enabled
fix 6778642 = enabled
fix 6699059 = enabled
fix 6376551 = enabled
fix 6429113 = enabled
fix 6782437 = enabled
fix 6776808 = enabled
fix 6765823 = enabled
fix 6768660 = enabled
fix 6782665 = enabled
fix 6610822 = enabled
fix 6514189 = enabled
fix 6818410 = enabled
fix 6827696 = enabled
fix 6773613 = enabled
fix 5902962 = enabled
fix 6956212 = enabled
fix 3056297 = enabled
fix 6440977 = disabled
fix 6972291 = disabled
fix 6904146 = enabled
fix 6221403 = enabled
fix 5475051 = enabled
fix 6845871 = enabled
fix 5468809 = enabled
fix 6917633 = enabled
fix 4444536 = disabled
fix 6955210 = enabled
fix 6994194 = enabled
fix 6399597 = disabled
fix 6951776 = enabled
fix 5648287 = 3
fix 6987082 = disabled
fix 7132036 = enabled
fix 6980350 = enabled
fix 5199213 = enabled
fix 7138405 = enabled
fix 7148689 = enabled
fix 6820988 = enabled
fix 7032684 = enabled
fix 6617866 = enabled
fix 7155968 = enabled
fix 7127980 = enabled
fix 6982954 = enabled
fix 7241819 = enabled
fix 6897034 = enabled
fix 7236148 = enabled
fix 7298570 = enabled
fix 7249095 = enabled
fix 7314499 = enabled
fix 7324224 = enabled
fix 7289023 = enabled
fix 7237571 = enabled
fix 7116357 = enabled
fix 7345484 = enabled
fix 7375179 = enabled
fix 6430500 = disabled
fix 5897486 = enabled
fix 6774209 = enabled
fix 7306637 = enabled
fix 6451322 = enabled
fix 7208131 = enabled
fix 7388652 = enabled
fix 7127530 = enabled
fix 6751206 = enabled
fix 6669103 = enabled
fix 7430474 = enabled
fix 6990305 = enabled
fix 7043307 = enabled
fix 3120429 = enabled
fix 7452823 = disabled
fix 6838105 = enabled
fix 6769711 = enabled
fix 7170213 = enabled
fix 6528872 = enabled
fix 7295298 = enabled
fix 5922070 = enabled
fix 7259468 = enabled
fix 6418552 = enabled
fix 4619997 = enabled
fix 7524366 = enabled
fix 6942476 = enabled
fix 6418771 = enabled
fix 7375077 = enabled
fix 5400639 = enabled
fix 4570921 = enabled
fix 7426911 = enabled
fix 5099019 = disabled
fix 7528216 = enabled
fix 7521266 = enabled
fix 7385140 = enabled
fix 7576516 = enabled
fix 7573526 = enabled
fix 7576476 = enabled
fix 7165898 = enabled
fix 7263214 = enabled
fix 3320140 = enabled
fix 7555510 = enabled
fix 7613118 = enabled
fix 7597059 = enabled
fix 7558911 = enabled
fix 5520732 = enabled
fix 7679490 = disabled
fix 7449971 = enabled
fix 3628118 = enabled
fix 4370840 = enabled
fix 7281191 = enabled
fix 7519687 = enabled
fix 5029592 = 3
fix 6012093 = 1
fix 6053861 = disabled
fix 6941515 = disabled
fix 7696414 = enabled
fix 7272039 = enabled
fix 7834811 = enabled
fix 7640597 = enabled
fix 7341616 = enabled
fix 7168184 = enabled
fix 399198 = enabled
fix 7831070 = enabled
fix 7676897 = disabled
fix 7414637 = enabled
fix 7585456 = enabled
fix 8202421 = enabled
fix 7658097 = disabled
fix 8251486 = enabled
fix 7132684 = enabled
fix 7512227 = enabled
fix 6972987 = enabled
fix 7199035 = enabled
fix 8243446 = enabled
fix 7650462 = enabled
fix 6720701 = enabled
fix 7592673 = enabled
fix 7718694 = enabled
fix 7534027 = enabled
fix 7708267 = enabled
fix 5716785 = enabled
fix 7356191 = enabled
fix 7679161 = enabled
fix 7597159 = enabled
fix 7499258 = enabled
fix 8328363 = enabled
fix 7452863 = enabled
fix 8284930 = enabled
fix 7298626 = enabled
fix 7657126 = enabled
fix 8371884 = enabled
fix 8318020 = enabled
fix 8255423 = enabled
fix 7135745 = enabled
fix 8356253 = enabled
fix 7534257 = enabled
fix 8323407 = enabled
fix 7539815 = enabled
fix 8289316 = enabled
fix 8447850 = enabled
fix 7675944 = enabled
fix 8355120 = enabled
fix 7176746 = enabled
fix 8442891 = enabled
fix 8373261 = enabled
fix 7679164 = enabled
fix 7670533 = enabled
fix 8408665 = enabled
fix 8491399 = enabled
fix 8348392 = enabled
fix 8348585 = enabled
fix 8508056 = enabled
fix 8335178 = enabled
fix 8515269 = enabled
fix 8247017 = enabled
fix 7325597 = enabled
fix 8531490 = enabled
fix 6163600 = enabled
fix 8589278 = disabled
fix 8557992 = enabled
fix 7556098 = enabled
fix 8580883 = enabled
fix 5892599 = disabled
fix 8609714 = enabled
fix 8619631 = disabled
fix 8672915 = enabled
fix 8514561 = enabled
fix 8213977 = enabled
fix 8560951 = disabled
fix 8578587 = enabled
fix 8287870 = enabled
fix 8467123 = enabled
fix 8602185 = enabled
fix 8519457 = enabled
fix 3335182 = enabled
fix 8602840 = enabled
fix 8725296 = enabled
fix 8628970 = enabled
fix 6754080 = enabled
fix 8767442 = enabled
fix 8760135 = enabled
fix 8644935 = enabled
fix 8352378 = enabled
fix 8685327 = enabled
fix 8763472 = enabled
fix 8773324 = enabled
fix 8813674 = enabled
fix 8532236 = enabled
fix 8629716 = enabled
fix 7277732 = enabled
fix 8692170 = enabled
fix 8900973 = enabled
fix 8919133 = enabled
fix 8927050 = enabled
fix 8551880 = enabled
fix 8901237 = enabled
fix 8812372 = enabled
fix 6236862 = enabled
fix 8528517 = enabled
fix 7215982 = enabled
fix 8214022 = enabled
fix 8595392 = enabled
fix 8890233 = enabled
fix 8999317 = enabled
fix 9004800 = enabled
fix 8986163 = enabled
fix 8855396 = enabled
fix 8800514 = 20
fix 9007859 = enabled
fix 8198783 = disabled
fix 9053879 = enabled
fix 6086930 = enabled
fix 7641601 = enabled
fix 9052506 = enabled
fix 9103775 = enabled
fix 9047975 = enabled
fix 8893626 = enabled
fix 9111170 = enabled
fix 8971829 = enabled
fix 7628358 = enabled
fix 9125151 = enabled
fix 9039715 = enabled
fix 9106224 = enabled
fix 9185228 = enabled
fix 9206747 = enabled
fix 9088510 = enabled
fix 9143856 = enabled
fix 8833381 = enabled
fix 8949971 = enabled
fix 8951812 = enabled
fix 9148171 = enabled
fix 8706652 = enabled
fix 9245114 = enabled
fix 8802198 = enabled
fix 9011016 = enabled
fix 9265681 = enabled
fix 7284269 = enabled
fix 9272549 = enabled
fix 8917507 = 7
fix 8531463 = enabled
fix 9263333 = enabled
fix 8675087 = enabled
fix 8571403 = enabled
fix 8896955 = enabled
fix 9041934 = enabled
fix 9344709 = enabled
fix 9024933 = enabled
fix 9033718 = enabled
fix 9240455 = enabled
fix 9081848 = enabled
fix 5982893 = enabled
fix 9287401 = enabled
fix 8590021 = enabled
fix 9340120 = enabled
fix 9355794 = enabled
fix 9356656 = enabled
fix 9385634 = enabled
fix 9069046 = enabled
fix 9239337 = enabled
fix 9300228 = enabled
fix 9298010 = enabled
fix 9384170 = enabled
fix 9407929 = enabled
fix 8836806 = enabled
fix 9344055 = enabled
fix 9274675 = enabled
fix 9203723 = enabled
fix 9443476 = enabled
fix 9195582 = enabled
fix 8226666 = enabled
fix 9433490 = enabled
fix 9065494 = enabled
fix 9303766 = enabled
fix 9437283 = enabled
fix 9116214 = enabled
fix 9456688 = enabled
fix 9456746 = disabled
fix 9342979 = enabled
fix 9465425 = enabled
fix 9092442 = enabled
fix 4926618 = enabled
fix 8792846 = enabled
fix 9474259 = enabled
fix 9495669 = disabled
fix 6472966 = enabled
fix 6408301 = enabled
fix 9380298 = disabled
fix 8500130 = enabled
fix 9584723 = enabled
fix 9270951 = enabled
fix 9508254 = enabled
fix 9593680 = enabled
fix 9196440 = disabled
fix 9309281 = enabled
fix 8693158 = enabled
fix 9381638 = enabled
fix 9383967 = enabled
fix 7711900 = enabled
fix 9218587 = enabled
fix 9728438 = enabled
fix 9038395 = enabled
fix 9577300 = enabled
fix 9171113 = enabled
fix 8973745 = enabled
fix 9732434 = enabled
fix 8937971 = disabled
fix 9102474 = enabled
fix 9243499 = enabled
fix 9791810 = enabled
fix 9785632 = enabled
fix 9898249 = enabled
fix 9153459 = enabled
fix 9680430 = enabled
fix 9841679 = enabled
fix 9912503 = enabled
fix 9850461 = enabled
fix 9762592 = 3
fix 9716877 = enabled
fix 9814067 = enabled
fix 9776736 = enabled
fix 8349119 = enabled
fix 9958518 = enabled
fix 10041074 = enabled
fix 10004943 = enabled
fix 9980661 = enabled
fix 9554026 = enabled
fix 9593547 = enabled
fix 9833381 = enabled
fix 10043801 = enabled
fix 9940732 = enabled
fix 9702850 = enabled
fix 9659125 = 0
fix 9668086 = enabled
fix 9476520 = enabled
fix 10158107 = enabled
fix 10148457 = enabled
fix 10106423 = enabled
fix 9721439 = disabled
fix 10162430 = enabled
fix 10134677 = enabled
fix 10182051 = 3
fix 10175079 = enabled
fix 10026972 = enabled
fix 10192889 = enabled
fix 3566843 = enabled
fix 9550277 = disabled
fix 10236566 = enabled
fix 10227392 = enabled
fix 8961143 = enabled
fix 9721228 = enabled
fix 10080014 = enabled
fix 10101489 = enabled
fix 9929609 = enabled
fix 10015652 = enabled
fix 9918661 = enabled
fix 10333395 = enabled
fix 10336499 = disabled
fix 10182672 = enabled
fix 9578670 = enabled
fix 10232225 = enabled
fix 10330090 = enabled
fix 10232623 = enabled
fix 9630092 = disabled
fix 10271790 = enabled
fix 9227576 = enabled
fix 10197666 = enabled
fix 10376744 = enabled
fix 8274946 = enabled
fix 10046368 = enabled
fix 9569678 = enabled
fix 9002661 = enabled
fix 10038373 = enabled
fix 9477688 = enabled
fix 10013899 = enabled
fix 9832338 = enabled
fix 10623119 = enabled
fix 9898066 = enabled
fix 11699884 = enabled
fix 10640430 = enabled
fix 10428450 = enabled
fix 10117760 = enabled
fix 11720178 = enabled
fix 9881812 = enabled
fix 10428278 = enabled
fix 11741436 = enabled
fix 11668189 = enabled
fix 10359631 = enabled
fix 9829887 = enabled
fix 8275054 = enabled
fix 11814428 = enabled
fix 11676888 = disabled
fix 10348427 = enabled
fix 11843512 = enabled
fix 11657468 = enabled
fix 11877160 = enabled
fix 11738631 = enabled
fix 11744086 = enabled
fix 11830663 = enabled
fix 11853331 = enabled
fix 9748015 = enabled
fix 11834739 = enabled
fix 6055658 = enabled
fix 11740670 = enabled
fix 11940126 = enabled
fix 12315002 = enabled
fix 8275023 = enabled
fix 12352373 = enabled
fix 12390139 = enabled
fix 11935589 = enabled
fix 10226906 = enabled
fix 12327548 = enabled
fix 12388221 = enabled
fix 11892888 = enabled
fix 11814265 = enabled
fix 10230017 = enabled
fix 12341619 = enabled
fix 11744016 = enabled
fix 10216738 = enabled
fix 10298302 = enabled
fix 12563419 = enabled
fix 12399886 = enabled
fix 12584007 = enabled
fix 11881047 = enabled
fix 12534597 = enabled
fix 8683604 = enabled
fix 12410972 = enabled
fix 7147087 = enabled
fix 11846314 = enabled
fix 12535474 = enabled
fix 12561635 = enabled
fix 12432426 = enabled
fix 9913117 = enabled
fix 12432089 = enabled
fix 12587690 = enabled
fix 11858963 = enabled
fix 12569245 = enabled
fix 12569300 = enabled
fix 7308975 = disabled
fix 12569316 = enabled
fix 12569321 = enabled
fix 12335617 = enabled
fix 9002958 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix 12313574 = enabled
fix 12569713 = enabled
fix 12348584 = enabled
fix 10420220 = enabled
fix 12559453 = enabled
fix 12727549 = enabled
fix 12728203 = enabled
fix 12828479 = enabled
fix 10181153 = enabled
fix 9971371 = disabled
fix 12864791 = enabled
fix 12810427 = enabled
fix 12605402 = enabled
fix 12914055 = enabled
fix 12861609 = enabled
fix 12915337 = enabled
fix 12942119 = enabled
fix 12622441 = enabled
fix 11072246 = enabled
fix 12739252 = enabled
fix 12953765 = enabled
fix 12905116 = enabled
fix 12978495 = enabled
fix 9633142 = disabled
fix 3639130 = enabled
fix 12827166 = enabled
fix 12944193 = enabled
fix 13020272 = enabled
fix 12673320 = enabled
fix 12975771 = enabled
fix 12882092 = enabled
fix 12379334 = enabled
fix 12723414 = enabled
fix 9488694 = disabled
fix 13255388 = 10
fix 11727871 = enabled
fix 13110511 = enabled
fix 13075297 = enabled
fix 13345888 = enabled
fix 11657903 = disabled
fix 13396096 = enabled
fix 12591379 = enabled
fix 13398214 = enabled
fix 13382280 = enabled
fix 12869367 = enabled
fix 12999577 = enabled
fix 12433153 = enabled
fix 9094254 = enabled
fix 13104618 = enabled
fix 13524237 = enabled
fix 11813257 = enabled
fix 13489017 = enabled
fix 12954320 = enabled
fix 13555551 = enabled
fix 13499154 = enabled
fix 13036910 = enabled
fix 13545925 = enabled
fix 13545956 = enabled
fix 13545989 = enabled
fix 12839247 = enabled
fix 9858777 = enabled
fix 13568366 = enabled
fix 13393357 = enabled
fix 13040171 = enabled
fix 13406619 = enabled
fix 13594757 = enabled
fix 13543207 = enabled
fix 13594712 = enabled
fix 12648629 = enabled
fix 13549808 = enabled
fix 13634700 = enabled
fix 8792821 = enabled
fix 13454409 = enabled
fix 13146487 = enabled
fix 13592248 = enabled
fix 11689541 = enabled
fix 13527374 = enabled
fix 13430622 = enabled
fix 13704562 = enabled
fix 9547706 = enabled
fix 13497184 = enabled
fix 13704977 = enabled
fix 13734456 = enabled
fix 13070532 = enabled
fix 6520878 = enabled
fix 2273284 = enabled
fix 13786127 = enabled
fix 13065064 = enabled
fix 13972896 = enabled
fix 11843466 = enabled
fix 13777823 = enabled
fix 13616573 = enabled
fix 13831671 = enabled
fix 13652216 = enabled
fix 13912192 = enabled
fix 13909909 = enabled
fix 13849486 = enabled
fix 13321547 = enabled
fix 13886606 = disabled
fix 14013502 = enabled
fix 13850256 = enabled
fix 13929275 = enabled
fix 11732303 = enabled
fix 13906168 = enabled
fix 14055128 = enabled
fix 12856200 = enabled
fix 14008590 = enabled
fix 13627489 = disabled
fix 13961105 = enabled
fix 13583722 = enabled
fix 13076238 = enabled
fix 13936229 = enabled
fix 9852856 = enabled
fix 3904125 = enabled
fix 5910187 = enabled
fix 10068316 = enabled
fix 14029891 = enabled
fix 4215125 = enabled
fix 13711083 = enabled
fix 13973691 = enabled
fix 13486825 = enabled
fix 13682550 = enabled
fix 13826669 = enabled
fix 14033181 = enabled
fix 13836796 = enabled
fix 12555499 = enabled
fix 13568506 = enabled
fix 9891396 = enabled
fix 13699643 = enabled
fix 13835788 = enabled
fix 7271518 = enabled
fix 14127824 = enabled
fix 12557401 = enabled
fix 13350470 = enabled
fix 14095362 = enabled
fix 13000118 = enabled
fix 14254795 = enabled
fix 14012261 = enabled
fix 14241953 = enabled
fix 14221012 = enabled
fix 13329748 = enabled
fix 13843964 = enabled
fix 14254052 = enabled
fix 13814866 = enabled
fix 14255600 = disabled
fix 13735304 = enabled
fix 14142884 = disabled
fix 12909121 = enabled
fix 14464068 = enabled
fix 14295250 = 45000
fix 6873091 = enabled
fix 13448445 = enabled
fix 14155722 = enabled
fix 14098180 = enabled
fix 11905801 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 13905599 = disabled
fix 14320077 = enabled
fix 14243782 = enabled
fix 9114915 = enabled
fix 14516175 = enabled
fix 12812697 = enabled
fix 13109345 = enabled
fix 14456124 = enabled
fix 14605040 = enabled
fix 14595273 = disabled
fix 14176247 = enabled
fix 11894476 = enabled
fix 14256885 = enabled
fix 14545269 = enabled
fix 14668404 = disabled
fix 14144611 = enabled
fix 14346182 = enabled
fix 13083139 = enabled
fix 14726188 = enabled
fix 14707009 = enabled
fix 14703133 = enabled
fix 14618560 = enabled
fix 14170552 = enabled
fix 13263174 = enabled
fix 14669785 = enabled
fix 14633570 = enabled
fix 14755138 = enabled
fix 14682092 = enabled
fix 14712222 = enabled
fix 14570575 = enabled
fix 14707748 = disabled
fix 14684079 = disabled
fix 13245379 = enabled
fix 13853916 = enabled
fix 13699007 = enabled
fix 14843189 = enabled
fix 14147762 = enabled
fix 14795969 = enabled
fix 13573073 = enabled
fix 14058291 = disabled
fix 16029607 = enabled
fix 16058481 = enabled
fix 16166364 = enabled
fix 16496848 = disabled
fix 12693573 = enabled
***************************************
PARAMETERS IN OPT_PARAM HINT
****************************
***************************************
Column Usage Monitoring is ON: tracking level = 1
***************************************
Considering Query Transformations on query block SEL$3 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No partitioned table in query block.
JF: Checking validity of join factorization for query block SEL$2 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$2 (#0)
TE: Bypassed: No partitioned table in query block.
Check Basic Validity for Non-Union View for query block SEL$2 (#0)
JPPD: JPPD bypassed: View has unsupported constructs.
Check Basic Validity for Non-Union View for query block SEL$1 (#0)
JPPD: JPPD bypassed: View has unsupported constructs.
JF: Checking validity of join factorization for query block SEL$3 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$3 (#0)
TE: Bypassed: No partitioned table in query block.
CBQT bypassed for query block SEL$3 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 1vnadspvk62bn.
CSE: Considering common sub-expression elimination in query block SEL$3 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: Considering common sub-expression elimination in query block SEL$2 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$2 (#0).
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
CSE: CSE not performed on query block SEL$3 (#0).
OBYE: Considering Order-by Elimination from view SEL$3 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE: OBYE bypassed: no order by to eliminate.
JE: Considering Join Elimination on query block SEL$1 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT "INFL2"."ID" "ID","INFL1"."PAYLOAD" "PAYLOAD" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2" WHERE "INFL1"."ID"="INFL2"."ID"
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL2 objn:92455 col#:1 dfro:INFL1 dcol#:1
SQL:******* UNPARSED QUERY IS *******
SELECT "INFL2"."ID" "ID","INFL1"."PAYLOAD" "PAYLOAD" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2" WHERE "INFL1"."ID"="INFL2"."ID"
Query block SEL$1 (#0) unchanged
JE: Considering Join Elimination on query block SEL$2 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT "INFL3"."ID" "ID","from$_subquery$_003"."PAYLOAD_1" "PAYLOAD" FROM (SELECT "INFL2"."ID" "ID_0","INFL1"."PAYLOAD" "PAYLOAD_1" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2" WHERE "INFL1"."ID"="INFL2"."ID") "from$_subquery$_003","RIK"."INFL3" "INFL3" WHERE "from$_subquery$_003"."ID_0"="INFL3"."ID"
SQL:******* UNPARSED QUERY IS *******
SELECT "INFL3"."ID" "ID","from$_subquery$_003"."PAYLOAD_1" "PAYLOAD" FROM (SELECT "INFL2"."ID" "ID_0","INFL1"."PAYLOAD" "PAYLOAD_1" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2" WHERE "INFL1"."ID"="INFL2"."ID") "from$_subquery$_003","RIK"."INFL3" "INFL3" WHERE "from$_subquery$_003"."ID_0"="INFL3"."ID"
Query block SEL$2 (#0) unchanged
CVM: Considering view merge in query block SEL$3 (#0)
OJE: Begin: find best directive for query block SEL$3 (#0)
OJE: End: finding best directive for query block SEL$3 (#0)
CNT: Considering count(col) to count(*) on query block SEL$3 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
CVM: Checking validity of merging in query block SEL$2 (#0)
CVM: Considering view merge in query block SEL$2 (#0)
OJE: Begin: find best directive for query block SEL$2 (#0)
OJE: End: finding best directive for query block SEL$2 (#0)
CVM: Checking validity of merging in query block SEL$1 (#0)
CVM: Considering view merge in query block SEL$1 (#0)
OJE: Begin: find best directive for query block SEL$1 (#0)
OJE: End: finding best directive for query block SEL$1 (#0)
CVM: Merging SPJ view SEL$1 (#0) into SEL$2 (#0)
Registered qb: SEL$58A6D7F6 0x719d2790 (VIEW MERGE SEL$2; SEL$1)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$58A6D7F6 nbfros=3 flg=0
fro(0): flg=0 objn=92455 hint_alias="INFL1"@"SEL$1"
fro(1): flg=0 objn=92457 hint_alias="INFL2"@"SEL$1"
fro(2): flg=0 objn=92459 hint_alias="INFL3"@"SEL$2"
OJE: Begin: find best directive for query block SEL$58A6D7F6 (#0)
OJE: End: finding best directive for query block SEL$58A6D7F6 (#0)
CVM: Merging SPJ view SEL$58A6D7F6 (#0) into SEL$3 (#0)
CNT: Considering count(col) to count(*) on query block SEL$3 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
Registered qb: SEL$9E43CB6E 0x719def80 (VIEW MERGE SEL$3; SEL$58A6D7F6)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$9E43CB6E nbfros=3 flg=0
fro(0): flg=0 objn=92455 hint_alias="INFL1"@"SEL$1"
fro(1): flg=0 objn=92457 hint_alias="INFL2"@"SEL$1"
fro(2): flg=0 objn=92459 hint_alias="INFL3"@"SEL$2"
OJE: Begin: find best directive for query block SEL$9E43CB6E (#0)
OJE: End: finding best directive for query block SEL$9E43CB6E (#0)
JE: Considering Join Elimination on query block SEL$9E43CB6E (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
JE: cfro: INFL2 objn:92459 col#:1 dfro:INFL3 dcol#:1
JE: cfro: INFL3 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL3 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL2 objn:92455 col#:1 dfro:INFL1 dcol#:1
SQL:******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
Query block SEL$9E43CB6E (#0) unchanged
query block SEL$3 transformed to SEL$9E43CB6E (#0)
Considering Query Transformations on query block SEL$9E43CB6E (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$9E43CB6E (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$9E43CB6E (#0)
TE: Bypassed: No partitioned table in query block.
CBQT bypassed for query block SEL$9E43CB6E (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 1vnadspvk62bn.
CSE: Considering common sub-expression elimination in query block SEL$9E43CB6E (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$9E43CB6E (#0).
SU: Considering subquery unnesting in query block SEL$9E43CB6E (#0)
********************
Subquery Unnest (SU)
********************
SJC: Considering set-join conversion in query block SEL$9E43CB6E (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: not performed
JE: Considering Join Elimination on query block SEL$9E43CB6E (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
JE: cfro: INFL2 objn:92459 col#:1 dfro:INFL3 dcol#:1
JE: cfro: INFL3 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL3 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL1 objn:92457 col#:1 dfro:INFL2 dcol#:1
JE: cfro: INFL2 objn:92455 col#:1 dfro:INFL1 dcol#:1
SQL:******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
Query block SEL$9E43CB6E (#0) unchanged
PM: Considering predicate move-around in query block SEL$9E43CB6E (#0)
**************************
Predicate Move-Around (PM)
**************************
PM: PM bypassed: Outer query contains no views.
PM: PM bypassed: Outer query contains no views.
query block SEL$9E43CB6E (#0) unchanged
FPD: Considering simple filter push in query block SEL$9E43CB6E (#0)
"INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
try to generate transitive predicate from check constraints for query block SEL$9E43CB6E (#0)
finally: "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
apadrv-start sqlid=2148584007735118196
CSE: Considering common sub-expression elimination in query block SEL$9E43CB6E (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$9E43CB6E (#0).
:
call(in-use=7792, alloc=16344), compile(in-use=76736, alloc=78488), execution(in-use=5776, alloc=8088)
*******************************************
Peeked values of the binds in SQL statement
*******************************************
=====================================
SPD: BEGIN context at statement level
=====================================
Stmt: ******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
Objects referenced in the statement
INFL3[INFL3] 92459, type = 1
INFL2[INFL2] 92457, type = 1
INFL1[INFL1] 92455, type = 1
Objects in the hash table
Hash table Object 92455, type = 1, ownerid = 12052497128556344610:
No Dynamic Sampling Directives for the object
Hash table Object 92457, type = 1, ownerid = 12377622192542048351:
No Dynamic Sampling Directives for the object
Hash table Object 92459, type = 1, ownerid = 2810570376276188060:
No Dynamic Sampling Directives for the object
Return code in qosdInitDirCtx: ENBLD
===================================
SPD: END context at statement level
===================================
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT COUNT(*) "COUNT(*)" FROM "RIK"."INFL1" "INFL1","RIK"."INFL2" "INFL2","RIK"."INFL3" "INFL3" WHERE "INFL2"."ID"="INFL3"."ID" AND "INFL1"."ID"="INFL2"."ID"
kkoqbc: optimizing query block SEL$9E43CB6E (#0)
:
call(in-use=8024, alloc=16344), compile(in-use=87248, alloc=90480), execution(in-use=5776, alloc=8088)
kkoqbc-subheap (create addr=0x7f5f725bfb60)
****************
QUERY BLOCK TEXT
****************
SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$9E43CB6E nbfros=3 flg=0
fro(0): flg=0 objn=92455 hint_alias="INFL1"@"SEL$1"
fro(1): flg=0 objn=92457 hint_alias="INFL2"@"SEL$1"
fro(2): flg=0 objn=92459 hint_alias="INFL3"@"SEL$2"
-----------------------------
SYSTEM STATISTICS INFORMATION
-----------------------------
Using NOWORKLOAD Stats
CPUSPEEDNW: 3281 millions instructions/sec (default is 100)
IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
IOSEEKTIM: 10 milliseconds (default is 10)
MBRC: NO VALUE blocks (default is 8)
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: INFL3 Alias: INFL3
#Rows: 846450 #Blks: 28457 AvgRowLen: 232.00 ChainCnt: 0.00
Column (#1): ID(NUMBER)
AvgLen: 6 NDV: 846450 Nulls: 0 Density: 0.000001 Min: 1000006.000000 Max: 10277380.000000
Index Stats::
Index: INFL3_PK Col#: 1
LVLS: 2 #LB: 3213 #DK: 846450 LB/K: 1.00 DB/K: 1.00 CLUF: 452707.00
***********************
Table Stats::
Table: INFL2 Alias: INFL2
#Rows: 846450 #Blks: 28329 AvgRowLen: 232.00 ChainCnt: 0.00
Column (#1): ID(NUMBER)
AvgLen: 6 NDV: 846450 Nulls: 0 Density: 0.000001 Min: 1000004.000000 Max: 10184920.000000
Index Stats::
Index: INFL2_PK Col#: 1
LVLS: 2 #LB: 3249 #DK: 846450 LB/K: 1.00 DB/K: 1.00 CLUF: 452548.00
***********************
Table Stats::
Table: INFL1 Alias: INFL1
#Rows: 846450 #Blks: 28329 AvgRowLen: 232.00 ChainCnt: 0.00
Column (#1): ID(NUMBER)
AvgLen: 6 NDV: 846450 Nulls: 0 Density: 0.000001 Min: 1000002.000000 Max: 10092460.000000
Index Stats::
Index: INFL1_PK Col#: 1
LVLS: 2 #LB: 3212 #DK: 846450 LB/K: 1.00 DB/K: 1.00 CLUF: 452707.00
=======================================
SPD: BEGIN context at query block level
=======================================
Query Block SEL$9E43CB6E (#0)
Return code in qosdSetupDirCtx4QB: NOCTX
=====================================
SPD: END context at query block level
=====================================
Access path analysis for INFL1
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for INFL1[INFL1]
SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
Table: INFL1 Alias: INFL1
Card: Original: 846450.000000 Rounded: 846450 Computed: 846450.00 Non Adjusted: 846450.00
Access Path: TableScan
Cost: 7682.35 Resp: 7682.35 Degree: 0
Cost_io: 7674.00 Cost_cpu: 328710774
Resp_io: 7674.00 Resp_cpu: 328710774
Access Path: index (index (FFS))
Index: INFL1_PK
resc_io: 872.00 resc_cpu: 124448065
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Access Path: index (FFS)
Cost: 875.16 Resp: 875.16 Degree: 1
Cost_io: 872.00 Cost_cpu: 124448065
Resp_io: 872.00 Resp_cpu: 124448065
Access Path: index (FullScan)
Index: INFL1_PK
resc_io: 3214.00 resc_cpu: 192178308
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3218.88 Resp: 3218.88 Degree: 1
Best:: AccessPath: IndexFFS
Index: INFL1_PK
Cost: 875.16 Degree: 1 Resp: 875.16 Card: 846450.00 Bytes: 0
Access path analysis for INFL2
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for INFL2[INFL2]
SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
Table: INFL2 Alias: INFL2
Card: Original: 846450.000000 Rounded: 846450 Computed: 846450.00 Non Adjusted: 846450.00
Access Path: TableScan
Cost: 7682.35 Resp: 7682.35 Degree: 0
Cost_io: 7674.00 Cost_cpu: 328710774
Resp_io: 7674.00 Resp_cpu: 328710774
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 882.00 resc_cpu: 124711559
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Access Path: index (FFS)
Cost: 885.17 Resp: 885.17 Degree: 1
Cost_io: 882.00 Cost_cpu: 124711559
Resp_io: 882.00 Resp_cpu: 124711559
Access Path: index (FullScan)
Index: INFL2_PK
resc_io: 3251.00 resc_cpu: 192441801
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3255.89 Resp: 3255.89 Degree: 1
Best:: AccessPath: IndexFFS
Index: INFL2_PK
Cost: 885.17 Degree: 1 Resp: 885.17 Card: 846450.00 Bytes: 0
Access path analysis for INFL3
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for INFL3[INFL3]
SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
Table: INFL3 Alias: INFL3
Card: Original: 846450.000000 Rounded: 846450 Computed: 846450.00 Non Adjusted: 846450.00
Access Path: TableScan
Cost: 7717.37 Resp: 7717.37 Degree: 0
Cost_io: 7709.00 Cost_cpu: 329622318
Resp_io: 7709.00 Resp_cpu: 329622318
Access Path: index (index (FFS))
Index: INFL3_PK
resc_io: 872.00 resc_cpu: 124455187
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Access Path: index (FFS)
Cost: 875.16 Resp: 875.16 Degree: 1
Cost_io: 872.00 Cost_cpu: 124455187
Resp_io: 872.00 Resp_cpu: 124455187
Access Path: index (FullScan)
Index: INFL3_PK
resc_io: 3215.00 resc_cpu: 192185430
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3219.88 Resp: 3219.88 Degree: 1
Best:: AccessPath: IndexFFS
Index: INFL3_PK
Cost: 875.16 Degree: 1 Resp: 875.16 Card: 846450.00 Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
PJE: Bypassed; QB is not duplicate insignificant SEL$9E43CB6E (#0)
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: INFL1[INFL1]#0 INFL2[INFL2]#1 INFL3[INFL3]#2
***************
Now joining: INFL2[INFL2]#1
***************
NL Join
Outer table: Card: 846450.00 Cost: 875.16 Resp: 875.16 Degree: 1 Bytes: 6
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6502312922.31 Resp: 6502312922.31 Degree: 1
Cost_io: 6494335596.00 Cost_cpu: 314061239022217
Resp_io: 6494335596.00 Resp_cpu: 314061239022217
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 748415254.93 Resp: 748415254.93 Degree: 1
Cost_io: 744823971.00 Cost_cpu: 141386103316177
Resp_io: 744823971.00 Resp_cpu: 141386103316177
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760645953
Resp_io: 847322.00 Resp_cpu: 7760645953
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760645953
Resp_io: 847322.00 Resp_cpu: 7760645953
Best NL cost: 847519.12
resc: 847519.12 resc_io: 847322.00 resc_cpu: 7760645953
resp: 847519.12 resp_io: 847322.00 resc_cpu: 7760645953
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 7236.74 Resp: 7236.74 [multiMatchCost=0.00]
SM Join
SM cost: 7236.74
resc: 7236.74 resc_io: 7190.00 resc_cpu: 1840235832
resp: 7236.74 resp_io: 7190.00 resp_cpu: 1840235832
SM Join (with index on outer)
Access Path: index (FullScan)
Index: INFL1_PK
resc_io: 3214.00 resc_cpu: 192178308
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3218.88 Resp: 3218.88 Degree: 1
Outer table: INFL1 Alias: INFL1
resc: 3218.88 card 846450.00 bytes: 6 deg: 1 resp: 3218.88
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 6842.26 Resp: 6842.26 [multiMatchCost=0.00]
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 1447.93 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 1860 ppasses: 1
Hash join: Resc: 3208.26 Resp: 3208.26 [multiMatchCost=0.00]
HA Join
HA cost: 3208.26
resc: 3208.26 resc_io: 3194.00 resc_cpu: 561278244
resp: 3208.26 resp_io: 3194.00 resp_cpu: 561278244
Best:: JoinMethod: Hash
Cost: 3208.26 Degree: 1 Resp: 3208.26 Card: 846450.00 Bytes: 12
***************
Now joining: INFL3[INFL3]#2
***************
NL Join
Outer table: Card: 846450.00 Cost: 3208.26 Resp: 3208.26 Degree: 1 Bytes: 12
Access path analysis for INFL3
Inner table: INFL3 Alias: INFL3
Access Path: TableScan
NL Join: Cost: 6531678453.88 Resp: 6531678453.88 Degree: 1
Cost_io: 6523681518.00 Cost_cpu: 314833252542060
Resp_io: 6523681518.00 Resp_cpu: 314833252542060
Access Path: index (index (FFS))
Index: INFL3_PK
resc_io: 870.19 resc_cpu: 166777687
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL3 Alias: INFL3
Access Path: index (FFS)
NL Join: Cost: 740159187.96 Resp: 740159187.96 Degree: 1
Cost_io: 736573405.00 Cost_cpu: 141169534202388
Resp_io: 736573405.00 Resp_cpu: 141169534202388
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197476132
Resp_io: 849644.00 Resp_cpu: 8197476132
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197476132
Resp_io: 849644.00 Resp_cpu: 8197476132
Best NL cost: 849852.22
resc: 849852.22 resc_io: 849644.00 resc_cpu: 8197476132
resp: 849852.22 resp_io: 849644.00 resc_cpu: 8197476132
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL2 Alias: INFL2
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 2488 Row size: 24 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 1348
Total IO sort cost: 3836 Total CPU sort cost: 813416580
Total Temp space used: 34005000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 10678.29 Resp: 10678.29 [multiMatchCost=0.00]
SM Join
SM cost: 10678.29
resc: 10678.29 resc_io: 10620.00 resc_cpu: 2294688115
resp: 10678.29 resp_io: 10620.00 resp_cpu: 2294688115
Outer table: INFL2 Alias: INFL2
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2480 probefrag: 1860 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
Outer table: INFL3 Alias: INFL3
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 3208.26 card: 846450.00 bytes: 12 deg: 1 resp: 3208.26
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 2480 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
HA Join
HA cost: 5771.41 swapped
resc: 5771.41 resc_io: 5746.00 resc_cpu: 1000395571
resp: 5771.41 resp_io: 5746.00 resp_cpu: 1000395571
Best:: JoinMethod: Hash
Cost: 5771.41 Degree: 1 Resp: 5771.41 Card: 846450.00 Bytes: 18
***********************
Best so far: Table#: 0 cost: 875.1610 card: 846450.0000 bytes: 5078700
Table#: 1 cost: 3208.2568 card: 846450.0000 bytes: 10157400
Table#: 2 cost: 5771.4106 card: 846450.0000 bytes: 15236100
***********************
Join order[2]: INFL1[INFL1]#0 INFL3[INFL3]#2 INFL2[INFL2]#1
***************
Now joining: INFL3[INFL3]#2
***************
NL Join
Outer table: Card: 846450.00 Cost: 875.16 Resp: 875.16 Degree: 1 Bytes: 6
Access path analysis for INFL3
Inner table: INFL3 Alias: INFL3
Access Path: TableScan
NL Join: Cost: 6530766174.74 Resp: 6530766174.74 Degree: 1
Cost_io: 6523679196.00 Cost_cpu: 279008935586881
Resp_io: 6523679196.00 Resp_cpu: 279008935586881
Access Path: index (index (FFS))
Index: INFL3_PK
resc_io: 870.19 resc_cpu: 124455187
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL3 Alias: INFL3
Access Path: index (FFS)
NL Join: Cost: 739246908.82 Resp: 739246908.82 Degree: 1
Cost_io: 736571083.00 Cost_cpu: 105345217247209
Resp_io: 736571083.00 Resp_cpu: 105345217247209
Access Path: index (FullScan)
Index: INFL3_PK
resc_io: 3215.00 resc_cpu: 192185430
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
NL Join : Cost: 2725469667.72 Resp: 2725469667.72 Degree: 1
Cost_io: 2721337622.00 Cost_cpu: 162675481332985
Resp_io: 2721337622.00 Resp_cpu: 162675481332985
Best NL cost: 739246908.82
resc: 739246908.82 resc_io: 736571083.00 resc_cpu: 105345217247209
resp: 739246908.82 resp_io: 736571083.00 resc_cpu: 105345217247209
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 716477602500.000000 = outer (846450.000000) * inner (846450.000000) * sel (1.000000)
Join Card - Rounded: 716477602500 Computed: 716477602500.00
Join order aborted: cost > best plan cost
***********************
Join order[3]: INFL2[INFL2]#1 INFL1[INFL1]#0 INFL3[INFL3]#2
***************
Now joining: INFL1[INFL1]#0
***************
NL Join
Outer table: Card: 846450.00 Cost: 885.17 Resp: 885.17 Degree: 1 Bytes: 6
Access path analysis for INFL1
Inner table: INFL1 Alias: INFL1
Access Path: TableScan
NL Join: Cost: 6502312932.32 Resp: 6502312932.32 Degree: 1
Cost_io: 6494335606.00 Cost_cpu: 314061239285711
Resp_io: 6494335606.00 Resp_cpu: 314061239285711
Access Path: index (index (FFS))
Index: INFL1_PK
resc_io: 869.92 resc_cpu: 166770565
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL1 Alias: INFL1
Access Path: index (FFS)
NL Join: Cost: 739927464.76 Resp: 739927464.76 Degree: 1
Cost_io: 736341846.00 Cost_cpu: 141163069692815
Resp_io: 736341846.00 Resp_cpu: 141163069692815
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847529.13 Resp: 847529.13 Degree: 1
Cost_io: 847332.00 Cost_cpu: 7760909447
Resp_io: 847332.00 Resp_cpu: 7760909447
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847529.13 Resp: 847529.13 Degree: 1
Cost_io: 847332.00 Cost_cpu: 7760909447
Resp_io: 847332.00 Resp_cpu: 7760909447
Best NL cost: 847529.13
resc: 847529.13 resc_io: 847332.00 resc_cpu: 7760909447
resp: 847529.13 resp_io: 847332.00 resc_cpu: 7760909447
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL2 Alias: INFL2
resc: 885.17 card 846450.00 bytes: 6 deg: 1 resp: 885.17
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 7236.74 Resp: 7236.74 [multiMatchCost=0.00]
SM Join
SM cost: 7236.74
resc: 7236.74 resc_io: 7190.00 resc_cpu: 1840235832
resp: 7236.74 resp_io: 7190.00 resp_cpu: 1840235832
SM Join (with index on outer)
Access Path: index (FullScan)
Index: INFL2_PK
resc_io: 3251.00 resc_cpu: 192441801
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3255.89 Resp: 3255.89 Degree: 1
Outer table: INFL2 Alias: INFL2
resc: 3255.89 card 846450.00 bytes: 6 deg: 1 resp: 3255.89
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 6869.26 Resp: 6869.26 [multiMatchCost=0.00]
Outer table: INFL2 Alias: INFL2
resc: 885.17 card 846450.00 bytes: 6 deg: 1 resp: 885.17
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1447.93 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 1860 ppasses: 1
Hash join: Resc: 3208.26 Resp: 3208.26 [multiMatchCost=0.00]
HA Join
HA cost: 3208.26
resc: 3208.26 resc_io: 3194.00 resc_cpu: 561278244
resp: 3208.26 resp_io: 3194.00 resp_cpu: 561278244
Best:: JoinMethod: Hash
Cost: 3208.26 Degree: 1 Resp: 3208.26 Card: 846450.00 Bytes: 12
***************
Now joining: INFL3[INFL3]#2
***************
NL Join
Outer table: Card: 846450.00 Cost: 3208.26 Resp: 3208.26 Degree: 1 Bytes: 12
Access path analysis for INFL3
Inner table: INFL3 Alias: INFL3
Access Path: TableScan
NL Join: Cost: 6531678453.88 Resp: 6531678453.88 Degree: 1
Cost_io: 6523681518.00 Cost_cpu: 314833252542060
Resp_io: 6523681518.00 Resp_cpu: 314833252542060
Access Path: index (index (FFS))
Index: INFL3_PK
resc_io: 870.19 resc_cpu: 166777687
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL3 Alias: INFL3
Access Path: index (FFS)
NL Join: Cost: 740159187.96 Resp: 740159187.96 Degree: 1
Cost_io: 736573405.00 Cost_cpu: 141169534202388
Resp_io: 736573405.00 Resp_cpu: 141169534202388
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197476132
Resp_io: 849644.00 Resp_cpu: 8197476132
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197476132
Resp_io: 849644.00 Resp_cpu: 8197476132
Best NL cost: 849852.22
resc: 849852.22 resc_io: 849644.00 resc_cpu: 8197476132
resp: 849852.22 resp_io: 849644.00 resc_cpu: 8197476132
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL1 Alias: INFL1
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 2488 Row size: 24 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 1348
Total IO sort cost: 3836 Total CPU sort cost: 813416580
Total Temp space used: 34005000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 10678.29 Resp: 10678.29 [multiMatchCost=0.00]
SM Join
SM cost: 10678.29
resc: 10678.29 resc_io: 10620.00 resc_cpu: 2294688115
resp: 10678.29 resp_io: 10620.00 resp_cpu: 2294688115
Outer table: INFL1 Alias: INFL1
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2480 probefrag: 1860 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
Outer table: INFL3 Alias: INFL3
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL1 Alias: INFL1
resc: 3208.26 card: 846450.00 bytes: 12 deg: 1 resp: 3208.26
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 2480 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
HA Join
HA cost: 5771.41 swapped
resc: 5771.41 resc_io: 5746.00 resc_cpu: 1000395571
resp: 5771.41 resp_io: 5746.00 resp_cpu: 1000395571
Join order aborted: cost > best plan cost
***********************
Join order[4]: INFL2[INFL2]#1 INFL3[INFL3]#2 INFL1[INFL1]#0
***************
Now joining: INFL3[INFL3]#2
***************
NL Join
Outer table: Card: 846450.00 Cost: 885.17 Resp: 885.17 Degree: 1 Bytes: 6
Access path analysis for INFL3
Inner table: INFL3 Alias: INFL3
Access Path: TableScan
NL Join: Cost: 6531676130.79 Resp: 6531676130.79 Degree: 1
Cost_io: 6523679206.00 Cost_cpu: 314832815975375
Resp_io: 6523679206.00 Resp_cpu: 314832815975375
Access Path: index (index (FFS))
Index: INFL3_PK
resc_io: 870.19 resc_cpu: 166777687
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL3 Alias: INFL3
Access Path: index (FFS)
NL Join: Cost: 740156864.87 Resp: 740156864.87 Degree: 1
Cost_io: 736571093.00 Cost_cpu: 141169097635703
Resp_io: 736571093.00 Resp_cpu: 141169097635703
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847529.13 Resp: 847529.13 Degree: 1
Cost_io: 847332.00 Cost_cpu: 7760909447
Resp_io: 847332.00 Resp_cpu: 7760909447
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL3_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847529.13 Resp: 847529.13 Degree: 1
Cost_io: 847332.00 Cost_cpu: 7760909447
Resp_io: 847332.00 Resp_cpu: 7760909447
Best NL cost: 847529.13
resc: 847529.13 resc_io: 847332.00 resc_cpu: 7760909447
resp: 847529.13 resp_io: 847332.00 resc_cpu: 7760909447
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL2 Alias: INFL2
resc: 885.17 card 846450.00 bytes: 6 deg: 1 resp: 885.17
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 7236.74 Resp: 7236.74 [multiMatchCost=0.00]
SM Join
SM cost: 7236.74
resc: 7236.74 resc_io: 7190.00 resc_cpu: 1840242954
resp: 7236.74 resp_io: 7190.00 resp_cpu: 1840242954
SM Join (with index on outer)
Access Path: index (FullScan)
Index: INFL2_PK
resc_io: 3251.00 resc_cpu: 192441801
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3255.89 Resp: 3255.89 Degree: 1
Outer table: INFL2 Alias: INFL2
resc: 3255.89 card 846450.00 bytes: 6 deg: 1 resp: 3255.89
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 6869.26 Resp: 6869.26 [multiMatchCost=0.00]
Outer table: INFL2 Alias: INFL2
resc: 885.17 card 846450.00 bytes: 6 deg: 1 resp: 885.17
Inner table: INFL3 Alias: INFL3
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1447.93 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 1860 ppasses: 1
Hash join: Resc: 3208.26 Resp: 3208.26 [multiMatchCost=0.00]
HA Join
HA cost: 3208.26
resc: 3208.26 resc_io: 3194.00 resc_cpu: 561285365
resp: 3208.26 resp_io: 3194.00 resp_cpu: 561285365
Best:: JoinMethod: Hash
Cost: 3208.26 Degree: 1 Resp: 3208.26 Card: 846450.00 Bytes: 12
***************
Now joining: INFL1[INFL1]#0
***************
NL Join
Outer table: Card: 846450.00 Cost: 3208.26 Resp: 3208.26 Degree: 1 Bytes: 12
Access path analysis for INFL1
Inner table: INFL1 Alias: INFL1
Access Path: TableScan
NL Join: Cost: 6502315255.41 Resp: 6502315255.41 Degree: 1
Cost_io: 6494337918.00 Cost_cpu: 314061675859517
Resp_io: 6494337918.00 Resp_cpu: 314061675859517
Access Path: index (index (FFS))
Index: INFL1_PK
resc_io: 869.92 resc_cpu: 166770565
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL1 Alias: INFL1
Access Path: index (FFS)
NL Join: Cost: 739929787.85 Resp: 739929787.85 Degree: 1
Cost_io: 736344158.00 Cost_cpu: 141163506266621
Resp_io: 736344158.00 Resp_cpu: 141163506266621
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197483253
Resp_io: 849644.00 Resp_cpu: 8197483253
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197483253
Resp_io: 849644.00 Resp_cpu: 8197483253
Best NL cost: 849852.22
resc: 849852.22 resc_io: 849644.00 resc_cpu: 8197483253
resp: 849852.22 resp_io: 849644.00 resc_cpu: 8197483253
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL3 Alias: INFL3
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 2488 Row size: 24 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 1348
Total IO sort cost: 3836 Total CPU sort cost: 813416580
Total Temp space used: 34005000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 10678.29 Resp: 10678.29 [multiMatchCost=0.00]
SM Join
SM cost: 10678.29
resc: 10678.29 resc_io: 10620.00 resc_cpu: 2294688115
resp: 10678.29 resp_io: 10620.00 resp_cpu: 2294688115
Outer table: INFL3 Alias: INFL3
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2480 probefrag: 1860 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL3 Alias: INFL3
resc: 3208.26 card: 846450.00 bytes: 12 deg: 1 resp: 3208.26
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 2480 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
HA Join
HA cost: 5771.41 swapped
resc: 5771.41 resc_io: 5746.00 resc_cpu: 1000395571
resp: 5771.41 resp_io: 5746.00 resp_cpu: 1000395571
Join order aborted: cost > best plan cost
***********************
Join order[5]: INFL3[INFL3]#2 INFL1[INFL1]#0 INFL2[INFL2]#1
***************
Now joining: INFL1[INFL1]#0
***************
NL Join
Outer table: Card: 846450.00 Cost: 875.16 Resp: 875.16 Degree: 1 Bytes: 6
Access path analysis for INFL1
Inner table: INFL1 Alias: INFL1
Access Path: TableScan
NL Join: Cost: 6501402976.27 Resp: 6501402976.27 Degree: 1
Cost_io: 6494335596.00 Cost_cpu: 278237358904339
Resp_io: 6494335596.00 Resp_cpu: 278237358904339
Access Path: index (index (FFS))
Index: INFL1_PK
resc_io: 869.92 resc_cpu: 124448065
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL1 Alias: INFL1
Access Path: index (FFS)
NL Join: Cost: 739017508.71 Resp: 739017508.71 Degree: 1
Cost_io: 736341836.00 Cost_cpu: 105339189311443
Resp_io: 736341836.00 Resp_cpu: 105339189311443
Access Path: index (FullScan)
Index: INFL1_PK
resc_io: 3214.00 resc_cpu: 192178308
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
NL Join : Cost: 2724623064.60 Resp: 2724623064.60 Degree: 1
Cost_io: 2720491172.00 Cost_cpu: 162669453397219
Resp_io: 2720491172.00 Resp_cpu: 162669453397219
Best NL cost: 739017508.71
resc: 739017508.71 resc_io: 736341836.00 resc_cpu: 105339189311443
resp: 739017508.71 resp_io: 736341836.00 resc_cpu: 105339189311443
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 716477602500.000000 = outer (846450.000000) * inner (846450.000000) * sel (1.000000)
Join Card - Rounded: 716477602500 Computed: 716477602500.00
Join order aborted: cost > best plan cost
***********************
Join order[6]: INFL3[INFL3]#2 INFL2[INFL2]#1 INFL1[INFL1]#0
***************
Now joining: INFL2[INFL2]#1
***************
NL Join
Outer table: Card: 846450.00 Cost: 875.16 Resp: 875.16 Degree: 1 Bytes: 6
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6502312922.31 Resp: 6502312922.31 Degree: 1
Cost_io: 6494335596.00 Cost_cpu: 314061239029339
Resp_io: 6494335596.00 Resp_cpu: 314061239029339
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 748415254.93 Resp: 748415254.93 Degree: 1
Cost_io: 744823971.00 Cost_cpu: 141386103323299
Resp_io: 744823971.00 Resp_cpu: 141386103323299
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760653075
Resp_io: 847322.00 Resp_cpu: 7760653075
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760653075
Resp_io: 847322.00 Resp_cpu: 7760653075
Best NL cost: 847519.12
resc: 847519.12 resc_io: 847322.00 resc_cpu: 7760653075
resp: 847519.12 resp_io: 847322.00 resc_cpu: 7760653075
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL3 Alias: INFL3
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 7236.74 Resp: 7236.74 [multiMatchCost=0.00]
SM Join
SM cost: 7236.74
resc: 7236.74 resc_io: 7190.00 resc_cpu: 1840242954
resp: 7236.74 resp_io: 7190.00 resp_cpu: 1840242954
SM Join (with index on outer)
Access Path: index (FullScan)
Index: INFL3_PK
resc_io: 3215.00 resc_cpu: 192185430
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 3219.88 Resp: 3219.88 Degree: 1
Outer table: INFL3 Alias: INFL3
resc: 3219.88 card 846450.00 bytes: 6 deg: 1 resp: 3219.88
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 6843.26 Resp: 6843.26 [multiMatchCost=0.00]
Outer table: INFL3 Alias: INFL3
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 1447.93 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 1860 ppasses: 1
Hash join: Resc: 3208.26 Resp: 3208.26 [multiMatchCost=0.00]
HA Join
HA cost: 3208.26
resc: 3208.26 resc_io: 3194.00 resc_cpu: 561285365
resp: 3208.26 resp_io: 3194.00 resp_cpu: 561285365
Best:: JoinMethod: Hash
Cost: 3208.26 Degree: 1 Resp: 3208.26 Card: 846450.00 Bytes: 12
***************
Now joining: INFL1[INFL1]#0
***************
NL Join
Outer table: Card: 846450.00 Cost: 3208.26 Resp: 3208.26 Degree: 1 Bytes: 12
Access path analysis for INFL1
Inner table: INFL1 Alias: INFL1
Access Path: TableScan
NL Join: Cost: 6502315255.41 Resp: 6502315255.41 Degree: 1
Cost_io: 6494337918.00 Cost_cpu: 314061675859517
Resp_io: 6494337918.00 Resp_cpu: 314061675859517
Access Path: index (index (FFS))
Index: INFL1_PK
resc_io: 869.92 resc_cpu: 166770565
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL1 Alias: INFL1
Access Path: index (FFS)
NL Join: Cost: 739929787.85 Resp: 739929787.85 Degree: 1
Cost_io: 736344158.00 Cost_cpu: 141163506266621
Resp_io: 736344158.00 Resp_cpu: 141163506266621
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197483253
Resp_io: 849644.00 Resp_cpu: 8197483253
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL1_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join : Cost: 849852.22 Resp: 849852.22 Degree: 1
Cost_io: 849644.00 Cost_cpu: 8197483253
Resp_io: 849644.00 Resp_cpu: 8197483253
Best NL cost: 849852.22
resc: 849852.22 resc_io: 849644.00 resc_cpu: 8197483253
resp: 849852.22 resp_io: 849644.00 resc_cpu: 8197483253
SPD: Return code in qosdDSDirSetup: NOCTX, estType = JOIN
Join Card: 846450.000000 = outer (846450.000000) * inner (846450.000000) * sel (0.000001)
Join Card - Rounded: 846450 Computed: 846450.00
Outer table: INFL2 Alias: INFL2
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 2488 Row size: 24 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 1348
Total IO sort cost: 3836 Total CPU sort cost: 813416580
Total Temp space used: 34005000
SORT ressource Sort statistics
Sort width: 319 Area size: 280576 Max Area size: 56203264
Degree: 1
Blocks to Sort: 1762 Row size: 17 Total Rows: 846450
Initial runs: 2 Merge passes: 1 IO Cost / pass: 956
Total IO sort cost: 2718 Total CPU sort cost: 795538104
Total Temp space used: 20407000
SM join: Resc: 10678.29 Resp: 10678.29 [multiMatchCost=0.00]
SM Join
SM cost: 10678.29
resc: 10678.29 resc_io: 10620.00 resc_cpu: 2294688115
resp: 10678.29 resp_io: 10620.00 resp_cpu: 2294688115
Outer table: INFL2 Alias: INFL2
resc: 3208.26 card 846450.00 bytes: 12 deg: 1 resp: 3208.26
Inner table: INFL1 Alias: INFL1
resc: 875.16 card: 846450.00 bytes: 6 deg: 1 resp: 875.16
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2480 probefrag: 1860 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 3208.26 card: 846450.00 bytes: 12 deg: 1 resp: 3208.26
using dmeth: 2 #groups: 1
Cost per ptn: 1687.99 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 2480 ppasses: 1
Hash join: Resc: 5771.41 Resp: 5771.41 [multiMatchCost=0.00]
HA Join
HA cost: 5771.41 swapped
resc: 5771.41 resc_io: 5746.00 resc_cpu: 1000395571
resp: 5771.41 resp_io: 5746.00 resp_cpu: 1000395571
Join order aborted: cost > best plan cost
***********************
(newjo-stop-1) k:0, spcnt:0, perm:6, maxperm:2000
*********************************
Number of join permutations tried: 6
*********************************
Consider using bloom filter between INFL1[INFL1] and INFL2[INFL2] with ??
kkoBloomFilter: join (lcdn:846450 rcdn:846450 jcdn:846450 limit:358238801250)
kkopqSingleJoinBloomNdv:Compute bloom ndv for lfro:INFL1[INFL1] and rfro:INFL2[INFL2] swap:no
kkopqSingleJoinBloomNdv: predCnt:#1 col1:(bndv:846450 ndv:846450) and col2:(bndv:846450 ndv:846450) creatorNDV:846450.0 userNDV:846450.0
kkopqComputeBloomNdv: predCnt:1 creatorNdv:846450.0 userNdv:846450.0 singleTblPred:no
kkoBloomFilter: join ndv:0 reduction:1.000000 (limit:0.500000) rejected because no single-tables predicates
Consider using bloom filter between INFL2[INFL2] and INFL3[INFL3] with ?? and join inputs swapped
kkoBloomFilter: join (lcdn:846450 rcdn:846450 jcdn:846450 limit:358238801250)
kkopqSingleJoinBloomNdv:Compute bloom ndv for lfro:INFL1[INFL1] and rfro:INFL3[INFL3] swap:yes
kkopqSingleJoinBloomNdv:Compute bloom ndv for lfro:INFL2[INFL2] and rfro:INFL3[INFL3] swap:yes
kkopqSingleJoinBloomNdv: predCnt:#1 col1:(bndv:846450 ndv:846450) and col2:(bndv:846450 ndv:846450) creatorNDV:846450.0 userNDV:846450.0
kkopqComputeBloomNdv: predCnt:1 creatorNdv:846450.0 userNdv:846450.0 singleTblPred:no
kkoBloomFilter: join ndv:0 reduction:1.000000 (limit:0.500000) rejected because no single-tables predicates
Enumerating distribution method (advanced)
--- Distribution method for
join between INFL1[INFL1](serial) and INFL2[INFL2](serial); jm = 1; right side access path = IndexFFS
---- serial Hash-Join -> NONE
--- Distribution method for
join between INFL2[INFL2](serial) and INFL3[INFL3](serial); jm = 1; right side access path = IndexFFS
---- serial Hash-Join -> NONE
(newjo-save) [2 1 0 ]
Trying or-Expansion on query block SEL$9E43CB6E (#0)
Transfer Optimizer annotations for query block SEL$9E43CB6E (#0)
DP: Checking validity for query block SEL$9E43CB6E, sqlid=1vnadspvk62bn.
kkopqIsSerialJoin: serial - SMJ/HJ: both input serial
Searching for inflection point (join #1) between 0.00 and 846450.00
AP: Computing costs for inflection point at min value 0.00
DP: Using binary search for inflection point search
DP: Costing Nested Loops Join for inflection point at card 0.00
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 8558.59 Resp: 8558.59 Degree: 1
Cost_io: 8546.00 Cost_cpu: 495481339
Resp_io: 8546.00 Resp_cpu: 495481339
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 882.00 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 1761.40 Resp: 1761.40 Degree: 1
Cost_io: 1754.00 Cost_cpu: 291482124
Resp_io: 1754.00 Resp_cpu: 291482124
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 876.16 Resp: 876.16 Degree: 1
Cost_io: 873.00 Cost_cpu: 124457087
Resp_io: 873.00 Resp_cpu: 124457087
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 876.16 Resp: 876.16 Degree: 1
Cost_io: 873.00 Cost_cpu: 124457087
Resp_io: 873.00 Resp_cpu: 124457087
DP: Costing Hash Join for inflection point at card 0.00
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 0.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 0 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.49 Resp: 1762.49 [multiMatchCost=0.00]
AP: lcost=876.16, rcost=1762.49
AP: Computing costs for inflection point at max value 846450.00
DP: Costing Nested Loops Join for inflection point at card 846450.00
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6502312922.31 Resp: 6502312922.31 Degree: 1
Cost_io: 6494335596.00 Cost_cpu: 314061239022217
Resp_io: 6494335596.00 Resp_cpu: 314061239022217
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 748415254.93 Resp: 748415254.93 Degree: 1
Cost_io: 744823971.00 Cost_cpu: 141386103316177
Resp_io: 744823971.00 Resp_cpu: 141386103316177
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760645953
Resp_io: 847322.00 Resp_cpu: 7760645953
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 847519.12 Resp: 847519.12 Degree: 1
Cost_io: 847322.00 Cost_cpu: 7760645953
Resp_io: 847322.00 Resp_cpu: 7760645953
DP: Costing Hash Join for inflection point at card 846450.00
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 846450.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 1447.93 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 1860 probefrag: 1860 ppasses: 1
Hash join: Resc: 3208.26 Resp: 3208.26 [multiMatchCost=0.00]
AP: lcost=847519.12, rcost=3208.26
AP: Searching for inflection point at value 1.00
DP: Costing Nested Loops Join for inflection point at card 423225.00
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 3251156899.74 Resp: 3251156899.74 Degree: 1
Cost_io: 3247168235.00 Cost_cpu: 157030681735141
Resp_io: 3247168235.00 Resp_cpu: 157030681735141
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 374208065.55 Resp: 374208065.55 Degree: 1
Cost_io: 372412422.00 Cost_cpu: 70693113882121
Resp_io: 372412422.00 Resp_cpu: 70693113882121
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 424197.14 Resp: 424197.14 Degree: 1
Cost_io: 424097.00 Cost_cpu: 3942547009
Resp_io: 424097.00 Resp_cpu: 3942547009
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 424197.14 Resp: 424197.14 Degree: 1
Cost_io: 424097.00 Cost_cpu: 3942547009
Resp_io: 424097.00 Resp_cpu: 3942547009
DP: Costing Hash Join for inflection point at card 423225.00
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 423225.00 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 1086.22 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 930 probefrag: 1860 ppasses: 1
Hash join: Resc: 2846.55 Resp: 2846.55 [multiMatchCost=0.00]
AP: lcost=424197.14, rcost=2846.55
AP: Searching for inflection point at value 423225.00
DP: Costing Nested Loops Join for inflection point at card 211612.50
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 1625582728.66 Resp: 1625582728.66 Degree: 1
Cost_io: 1623588390.00 Cost_cpu: 78515588608240
Resp_io: 1623588390.00 Resp_cpu: 78515588608240
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 187104913.48 Resp: 187104913.48 Degree: 1
Cost_io: 186207088.00 Cost_cpu: 35346702682123
Resp_io: 186207088.00 Resp_cpu: 35346702682123
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 212536.65 Resp: 212536.65 Degree: 1
Cost_io: 212485.00 Cost_cpu: 2033502048
Resp_io: 212485.00 Resp_cpu: 2033502048
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 212536.65 Resp: 212536.65 Degree: 1
Cost_io: 212485.00 Cost_cpu: 2033502048
Resp_io: 212485.00 Resp_cpu: 2033502048
DP: Costing Hash Join for inflection point at card 211612.50
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 211612.50 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 905.36 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 465 probefrag: 1860 ppasses: 1
Hash join: Resc: 2665.69 Resp: 2665.69 [multiMatchCost=0.00]
AP: lcost=212536.65, rcost=2665.69
AP: Searching for inflection point at value 211612.50
DP: Costing Nested Loops Join for inflection point at card 105806.25
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 812787962.20 Resp: 812787962.20 Degree: 1
Cost_io: 811790796.00 Cost_cpu: 39257671011516
Resp_io: 811790796.00 Resp_cpu: 39257671011516
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 93552453.20 Resp: 93552453.20 Degree: 1
Cost_io: 93103541.00 Cost_cpu: 17673330048065
Resp_io: 93103541.00 Resp_cpu: 17673330048065
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 106705.41 Resp: 106705.41 Degree: 1
Cost_io: 106678.00 Cost_cpu: 1078970546
Resp_io: 106678.00 Resp_cpu: 1078970546
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 106705.41 Resp: 106705.41 Degree: 1
Cost_io: 106678.00 Cost_cpu: 1078970546
Resp_io: 106678.00 Resp_cpu: 1078970546
DP: Costing Hash Join for inflection point at card 105806.25
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 105806.25 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 815.94 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 233 probefrag: 1860 ppasses: 1
Hash join: Resc: 2576.27 Resp: 2576.27 [multiMatchCost=0.00]
AP: lcost=106705.41, rcost=2576.27
AP: Searching for inflection point at value 105806.25
DP: Costing Nested Loops Join for inflection point at card 52903.12
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 406394419.68 Resp: 406394419.68 Degree: 1
Cost_io: 405895835.00 Cost_cpu: 19628897729791
Resp_io: 405895835.00 Resp_cpu: 19628897729791
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 46776664.68 Resp: 46776664.68 Degree: 1
Cost_io: 46552207.00 Cost_cpu: 8836727248065
Resp_io: 46552207.00 Resp_cpu: 8836727248065
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 53790.28 Resp: 53790.28 Degree: 1
Cost_io: 53775.00 Cost_cpu: 601709306
Resp_io: 53775.00 Resp_cpu: 601709306
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 53790.28 Resp: 53790.28 Degree: 1
Cost_io: 53775.00 Cost_cpu: 601709306
Resp_io: 53775.00 Resp_cpu: 601709306
DP: Costing Hash Join for inflection point at card 52903.12
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 52903.12 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.37 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 117 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.70 Resp: 1762.70 [multiMatchCost=0.00]
AP: lcost=53790.28, rcost=1762.70
AP: Searching for inflection point at value 52903.12
DP: Costing Nested Loops Join for inflection point at card 26451.56
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 203201489.63 Resp: 203201489.63 Degree: 1
Cost_io: 202952191.00 Cost_cpu: 9814696605565
Resp_io: 202952191.00 Resp_cpu: 9814696605565
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 23389213.54 Resp: 23389213.54 Degree: 1
Cost_io: 23276981.00 Cost_cpu: 4418509365094
Resp_io: 23276981.00 Resp_cpu: 4418509365094
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 27333.22 Resp: 27333.22 Degree: 1
Cost_io: 27324.00 Cost_cpu: 363083196
Resp_io: 27324.00 Resp_cpu: 363083196
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 27333.22 Resp: 27333.22 Degree: 1
Cost_io: 27324.00 Cost_cpu: 363083196
Resp_io: 27324.00 Resp_cpu: 363083196
DP: Costing Hash Join for inflection point at card 26451.56
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 26451.56 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.27 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 59 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.59 Resp: 1762.59 [multiMatchCost=0.00]
AP: lcost=27333.22, rcost=1762.59
AP: Searching for inflection point at value 26451.56
DP: Costing Nested Loops Join for inflection point at card 13225.78
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 101601182.90 Resp: 101601182.90 Degree: 1
Cost_io: 101476532.00 Cost_cpu: 4907410526815
Resp_io: 101476532.00 Resp_cpu: 4907410526815
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 11695044.85 Resp: 11695044.85 Degree: 1
Cost_io: 11638927.00 Cost_cpu: 2209316906580
Resp_io: 11638927.00 Resp_cpu: 2209316906580
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 14104.19 Resp: 14104.19 Degree: 1
Cost_io: 14098.00 Cost_cpu: 243765631
Resp_io: 14098.00 Resp_cpu: 243765631
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 14104.19 Resp: 14104.19 Degree: 1
Cost_io: 14098.00 Cost_cpu: 243765631
Resp_io: 14098.00 Resp_cpu: 243765631
DP: Costing Hash Join for inflection point at card 13225.78
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 13225.78 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.22 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 30 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.54 Resp: 1762.54 [multiMatchCost=0.00]
AP: lcost=14104.19, rcost=1762.54
AP: Searching for inflection point at value 13225.78
DP: Costing Nested Loops Join for inflection point at card 6612.89
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 50801030.03 Resp: 50801030.03 Degree: 1
Cost_io: 50738703.00 Cost_cpu: 2453767487440
Resp_io: 50738703.00 Resp_cpu: 2453767487440
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 5847960.51 Resp: 5847960.51 Degree: 1
Cost_io: 5819900.00 Cost_cpu: 1104720677323
Resp_io: 5819900.00 Resp_cpu: 1104720677323
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 7489.68 Resp: 7489.68 Degree: 1
Cost_io: 7485.00 Cost_cpu: 184106848
Resp_io: 7485.00 Resp_cpu: 184106848
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 7489.68 Resp: 7489.68 Degree: 1
Cost_io: 7485.00 Cost_cpu: 184106848
Resp_io: 7485.00 Resp_cpu: 184106848
DP: Costing Hash Join for inflection point at card 6612.89
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 6612.89 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.19 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 15 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.52 Resp: 1762.52 [multiMatchCost=0.00]
AP: lcost=7489.68, rcost=1762.52
AP: Searching for inflection point at value 6612.89
DP: Costing Nested Loops Join for inflection point at card 3306.45
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 25397112.38 Resp: 25397112.38 Degree: 1
Cost_io: 25365952.00 Cost_cpu: 1226760451116
Resp_io: 25365952.00 Resp_cpu: 1226760451116
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 2923976.71 Resp: 2923976.71 Degree: 1
Cost_io: 2909947.00 Cost_cpu: 552339045665
Resp_io: 2909947.00 Resp_cpu: 552339045665
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 4181.92 Resp: 4181.92 Degree: 1
Cost_io: 4178.00 Cost_cpu: 154272946
Resp_io: 4178.00 Resp_cpu: 154272946
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 4181.92 Resp: 4181.92 Degree: 1
Cost_io: 4178.00 Cost_cpu: 154272946
Resp_io: 4178.00 Resp_cpu: 154272946
DP: Costing Hash Join for inflection point at card 3306.45
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 3306.45 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.18 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 8 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.51 Resp: 1762.51 [multiMatchCost=0.00]
AP: lcost=4181.92, rcost=1762.51
AP: Searching for inflection point at value 3306.45
DP: Costing Nested Loops Join for inflection point at card 1653.22
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 12698994.77 Resp: 12698994.77 Degree: 1
Cost_io: 12683413.00 Cost_cpu: 613442449591
Resp_io: 12683413.00 Resp_cpu: 613442449591
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 1462426.44 Resp: 1462426.44 Degree: 1
Cost_io: 1455410.00 Cost_cpu: 276231746865
Resp_io: 1455410.00 Resp_cpu: 276231746865
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 2528.54 Resp: 2528.54 Degree: 1
Cost_io: 2525.00 Cost_cpu: 139360506
Resp_io: 2525.00 Resp_cpu: 139360506
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 2528.54 Resp: 2528.54 Degree: 1
Cost_io: 2525.00 Cost_cpu: 139360506
Resp_io: 2525.00 Resp_cpu: 139360506
DP: Costing Hash Join for inflection point at card 1653.22
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 1653.22 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 4 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=2528.54, rcost=1762.50
AP: Searching for inflection point at value 1653.22
DP: Costing Nested Loops Join for inflection point at card 826.61
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6353777.18 Resp: 6353777.18 Degree: 1
Cost_io: 6345980.00 Cost_cpu: 306968965465
Resp_io: 6345980.00 Resp_cpu: 306968965465
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 732093.92 Resp: 732093.92 Degree: 1
Cost_io: 728582.00 Cost_cpu: 138261614494
Resp_io: 728582.00 Resp_cpu: 138261614494
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1702.35 Resp: 1702.35 Degree: 1
Cost_io: 1699.00 Cost_cpu: 131908796
Resp_io: 1699.00 Resp_cpu: 131908796
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1702.35 Resp: 1702.35 Degree: 1
Cost_io: 1699.00 Cost_cpu: 131908796
Resp_io: 1699.00 Resp_cpu: 131908796
DP: Costing Hash Join for inflection point at card 826.61
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 826.61 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1702.35, rcost=1762.50
AP: Searching for inflection point at value 826.61
DP: Costing Nested Loops Join for inflection point at card 1239.92
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 9526385.48 Resp: 9526385.48 Degree: 1
Cost_io: 9514696.00 Cost_cpu: 460205707528
Resp_io: 9514696.00 Resp_cpu: 460205707528
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 1097260.18 Resp: 1097260.18 Degree: 1
Cost_io: 1091996.00 Cost_cpu: 207246680680
Resp_io: 1091996.00 Resp_cpu: 207246680680
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 2115.45 Resp: 2115.45 Degree: 1
Cost_io: 2112.00 Cost_cpu: 135634651
Resp_io: 2112.00 Resp_cpu: 135634651
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 2115.45 Resp: 2115.45 Degree: 1
Cost_io: 2112.00 Cost_cpu: 135634651
Resp_io: 2112.00 Resp_cpu: 135634651
DP: Costing Hash Join for inflection point at card 1239.92
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 1239.92 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 3 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=2115.45, rcost=1762.50
AP: Searching for inflection point at value 1239.92
DP: Costing Nested Loops Join for inflection point at card 1033.26
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 7936240.61 Resp: 7936240.61 Degree: 1
Cost_io: 7926502.00 Cost_cpu: 383401819859
Resp_io: 7926502.00 Resp_cpu: 383401819859
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 914234.93 Resp: 914234.93 Degree: 1
Cost_io: 909849.00 Cost_cpu: 172670630558
Resp_io: 909849.00 Resp_cpu: 172670630558
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1908.40 Resp: 1908.40 Degree: 1
Cost_io: 1905.00 Cost_cpu: 133767213
Resp_io: 1905.00 Resp_cpu: 133767213
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1908.40 Resp: 1908.40 Degree: 1
Cost_io: 1905.00 Cost_cpu: 133767213
Resp_io: 1905.00 Resp_cpu: 133767213
DP: Costing Hash Join for inflection point at card 1033.26
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 1033.26 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 3 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1908.40, rcost=1762.50
AP: Searching for inflection point at value 1033.26
DP: Costing Nested Loops Join for inflection point at card 929.94
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 7145008.90 Resp: 7145008.90 Degree: 1
Cost_io: 7136241.00 Cost_cpu: 345185392662
Resp_io: 7136241.00 Resp_cpu: 345185392662
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 823164.92 Resp: 823164.92 Degree: 1
Cost_io: 819216.00 Cost_cpu: 155466122526
Resp_io: 819216.00 Resp_cpu: 155466122526
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1805.37 Resp: 1805.37 Degree: 1
Cost_io: 1802.00 Cost_cpu: 132838004
Resp_io: 1802.00 Resp_cpu: 132838004
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1805.37 Resp: 1805.37 Degree: 1
Cost_io: 1802.00 Cost_cpu: 132838004
Resp_io: 1802.00 Resp_cpu: 132838004
DP: Costing Hash Join for inflection point at card 929.94
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 929.94 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 3 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1805.37, rcost=1762.50
AP: Searching for inflection point at value 929.94
DP: Costing Nested Loops Join for inflection point at card 878.27
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6745551.83 Resp: 6745551.83 Degree: 1
Cost_io: 6737274.00 Cost_cpu: 325891662427
Resp_io: 6737274.00 Resp_cpu: 325891662427
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 777187.30 Resp: 777187.30 Degree: 1
Cost_io: 773459.00 Cost_cpu: 146780351481
Resp_io: 773459.00 Resp_cpu: 146780351481
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1753.36 Resp: 1753.36 Degree: 1
Cost_io: 1750.00 Cost_cpu: 132368890
Resp_io: 1750.00 Resp_cpu: 132368890
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1753.36 Resp: 1753.36 Degree: 1
Cost_io: 1750.00 Cost_cpu: 132368890
Resp_io: 1750.00 Resp_cpu: 132368890
DP: Costing Hash Join for inflection point at card 878.27
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 878.27 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1753.36, rcost=1762.50
AP: Searching for inflection point at value 878.27
DP: Costing Nested Loops Join for inflection point at card 904.11
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6945279.86 Resp: 6945279.86 Degree: 1
Cost_io: 6936757.00 Cost_cpu: 335538527544
Resp_io: 6936757.00 Resp_cpu: 335538527544
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 800175.61 Resp: 800175.61 Degree: 1
Cost_io: 796337.00 Cost_cpu: 151123237004
Resp_io: 796337.00 Resp_cpu: 151123237004
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1779.37 Resp: 1779.37 Degree: 1
Cost_io: 1776.00 Cost_cpu: 132603447
Resp_io: 1776.00 Resp_cpu: 132603447
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1779.37 Resp: 1779.37 Degree: 1
Cost_io: 1776.00 Cost_cpu: 132603447
Resp_io: 1776.00 Resp_cpu: 132603447
DP: Costing Hash Join for inflection point at card 904.11
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 904.11 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1779.37, rcost=1762.50
AP: Searching for inflection point at value 904.11
DP: Costing Nested Loops Join for inflection point at card 891.19
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6845416.34 Resp: 6845416.34 Degree: 1
Cost_io: 6837016.00 Cost_cpu: 330715094985
Resp_io: 6837016.00 Resp_cpu: 330715094985
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 788681.46 Resp: 788681.46 Degree: 1
Cost_io: 784898.00 Cost_cpu: 148951794242
Resp_io: 784898.00 Resp_cpu: 148951794242
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1766.37 Resp: 1766.37 Degree: 1
Cost_io: 1763.00 Cost_cpu: 132486168
Resp_io: 1763.00 Resp_cpu: 132486168
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1766.37 Resp: 1766.37 Degree: 1
Cost_io: 1763.00 Cost_cpu: 132486168
Resp_io: 1763.00 Resp_cpu: 132486168
DP: Costing Hash Join for inflection point at card 891.19
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 891.19 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1766.37, rcost=1762.50
AP: Searching for inflection point at value 891.19
DP: Costing Nested Loops Join for inflection point at card 884.73
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6799324.80 Resp: 6799324.80 Degree: 1
Cost_io: 6790981.00 Cost_cpu: 328488895343
Resp_io: 6790981.00 Resp_cpu: 328488895343
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 783376.00 Resp: 783376.00 Degree: 1
Cost_io: 779618.00 Cost_cpu: 147949589891
Resp_io: 779618.00 Resp_cpu: 147949589891
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1760.36 Resp: 1760.36 Degree: 1
Cost_io: 1757.00 Cost_cpu: 132432040
Resp_io: 1757.00 Resp_cpu: 132432040
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1760.36 Resp: 1760.36 Degree: 1
Cost_io: 1757.00 Cost_cpu: 132432040
Resp_io: 1757.00 Resp_cpu: 132432040
DP: Costing Hash Join for inflection point at card 884.73
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 884.73 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1760.36, rcost=1762.50
AP: Searching for inflection point at value 884.73
DP: Costing Nested Loops Join for inflection point at card 887.96
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6822370.07 Resp: 6822370.07 Degree: 1
Cost_io: 6813998.00 Cost_cpu: 329601995164
Resp_io: 6813998.00 Resp_cpu: 329601995164
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 786028.73 Resp: 786028.73 Degree: 1
Cost_io: 782258.00 Cost_cpu: 148450692067
Resp_io: 782258.00 Resp_cpu: 148450692067
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1763.36 Resp: 1763.36 Degree: 1
Cost_io: 1760.00 Cost_cpu: 132459104
Resp_io: 1760.00 Resp_cpu: 132459104
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1763.36 Resp: 1763.36 Degree: 1
Cost_io: 1760.00 Cost_cpu: 132459104
Resp_io: 1760.00 Resp_cpu: 132459104
DP: Costing Hash Join for inflection point at card 887.96
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 887.96 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1763.36, rcost=1762.50
AP: Searching for inflection point at value 887.96
DP: Costing Nested Loops Join for inflection point at card 886.35
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6807006.22 Resp: 6807006.22 Degree: 1
Cost_io: 6798653.00 Cost_cpu: 328859928617
Resp_io: 6798653.00 Resp_cpu: 328859928617
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 784260.24 Resp: 784260.24 Degree: 1
Cost_io: 780498.00 Cost_cpu: 148116623949
Resp_io: 780498.00 Resp_cpu: 148116623949
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1761.36 Resp: 1761.36 Degree: 1
Cost_io: 1758.00 Cost_cpu: 132441061
Resp_io: 1758.00 Resp_cpu: 132441061
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1761.36 Resp: 1761.36 Degree: 1
Cost_io: 1758.00 Cost_cpu: 132441061
Resp_io: 1758.00 Resp_cpu: 132441061
DP: Costing Hash Join for inflection point at card 886.35
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 886.35 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1761.36, rcost=1762.50
AP: Searching for inflection point at value 886.35
DP: Costing Nested Loops Join for inflection point at card 887.15
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6814688.65 Resp: 6814688.65 Degree: 1
Cost_io: 6806326.00 Cost_cpu: 329230961890
Resp_io: 6806326.00 Resp_cpu: 329230961890
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 785144.49 Resp: 785144.49 Degree: 1
Cost_io: 781378.00 Cost_cpu: 148283658008
Resp_io: 781378.00 Resp_cpu: 148283658008
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1762.36 Resp: 1762.36 Degree: 1
Cost_io: 1759.00 Cost_cpu: 132450083
Resp_io: 1759.00 Resp_cpu: 132450083
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1762.36 Resp: 1762.36 Degree: 1
Cost_io: 1759.00 Cost_cpu: 132450083
Resp_io: 1759.00 Resp_cpu: 132450083
DP: Costing Hash Join for inflection point at card 887.15
Outer table: INFL1 Alias: INFL1
resc: 875.16 card 887.15 bytes: 6 deg: 1 resp: 875.16
Inner table: INFL2 Alias: INFL2
resc: 885.17 card: 846450.00 bytes: 6 deg: 1 resp: 885.17
using dmeth: 2 #groups: 1
Cost per ptn: 2.17 #ptns: 1
hash_area: 124 (max=13722) buildfrag: 2 probefrag: 1860 ppasses: 1
Hash join: Resc: 1762.50 Resp: 1762.50 [multiMatchCost=0.00]
AP: lcost=1762.36, rcost=1762.50
DP: Costing Nested Loops Join for inflection point at card 887.15
Access path analysis for INFL2
Inner table: INFL2 Alias: INFL2
Access Path: TableScan
NL Join: Cost: 6814688.65 Resp: 6814688.65 Degree: 1
Cost_io: 6806326.00 Cost_cpu: 329230961890
Resp_io: 6806326.00 Resp_cpu: 329230961890
Access Path: index (index (FFS))
Index: INFL2_PK
resc_io: 879.94 resc_cpu: 167034059
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: INFL2 Alias: INFL2
Access Path: index (FFS)
NL Join: Cost: 785144.49 Resp: 785144.49 Degree: 1
Cost_io: 781378.00 Cost_cpu: 148283658008
Resp_io: 781378.00 Resp_cpu: 148283658008
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (UniqueScan)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1762.36 Resp: 1762.36 Degree: 1
Cost_io: 1759.00 Cost_cpu: 132450083
Resp_io: 1759.00 Resp_cpu: 132450083
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_SCAN
SPD: Return code in qosdDSDirSetup: NOCTX, estType = INDEX_FILTER
Access Path: index (AllEqUnique)
Index: INFL2_PK
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000001 ix_sel_with_filters: 0.000001
NL Join (ordered): Cost: 1762.36 Resp: 1762.36 Degree: 1
Cost_io: 1759.00 Cost_cpu: 132450083
Resp_io: 1759.00 Resp_cpu: 132450083
DP: Found point of inflection for NLJ vs. HJ: card = 887.15
kkopqIsSerialJoin: serial - SMJ/HJ: both input serial
DP: Dynamic joins bypassed for table INFL3 @ SEL$9E43CB6E due to Hash join is swapped
AutoDOP: Consider caching for INFL1[INFL1](obj#92456)
cost:875.16 blkSize:8192 objSize:3212.00 marObjSize:3051.40 bufSize:31360.00 affPercent:80 smallTab:NO affinitized:NO
kkecComputeAPDop: IO Dop: 0 - CPU Dop: 0
Replication not feasible based on distribution
Transfer optimizer annotations for INFL1[INFL1]
id=0 frofkks[i] (index start key) predicate="INFL1"."ID"="INFL2"."ID"
id=0 frofkke[i] (index stop key) predicate="INFL1"."ID"="INFL2"."ID"
Transfer optimizer annotations for INFL2[INFL2]
HJ temp:
AutoDOP: Consider caching for INFL2[INFL2](obj#92458)
cost:3208.26 blkSize:8192 objSize:3249.00 marObjSize:3086.55 bufSize:31360.00 affPercent:80 smallTab:NO affinitized:NO
kkecComputeAPDop: IO Dop: 0 - CPU Dop: 0
Replication not feasible based on distribution
id=0 frofkksm[i] (sort-merge/hash) predicate="INFL1"."ID"="INFL2"."ID"
id=0 frosand (sort-merge/hash) predicate="INFL1"."ID"="INFL2"."ID"
Transfer optimizer annotations for INFL2[INFL2]
HJ temp:
DP: Dynamic joins bypassed for table INFL3 @ SEL$9E43CB6E due to Swapped hash join
AutoDOP: Consider caching for INFL3[INFL3](obj#92460)
cost:5771.41 blkSize:8192 objSize:3213.00 marObjSize:3052.35 bufSize:31360.00 affPercent:80 smallTab:NO affinitized:NO
kkecComputeAPDop: IO Dop: 0 - CPU Dop: 0
Replication not feasible based on distribution
id=0 frofkksm[i] (sort-merge/hash) predicate="INFL2"."ID"="INFL3"."ID"
id=0 frosand (sort-merge/hash) predicate="INFL2"."ID"="INFL3"."ID"
Transfer optimizer annotations for INFL3[INFL3]
HJ temp:
Final cost for query block SEL$9E43CB6E (#0) - All Rows Plan:
Best join order: 1
Cost: 5771.4106 Degree: 1 Card: 846450.0000 Bytes: 15236100
Resc: 5771.4106 Resc_io: 5746.0000 Resc_cpu: 1000395571
Resp: 5771.4106 Resp_io: 5746.0000 Resc_cpu: 1000395571
kkoqbc-subheap (delete addr=0x7f5f725bfb60, in-use=41592, alloc=49272)
kkoqbc-end:
:
call(in-use=20072, alloc=98496), compile(in-use=106688, alloc=107064), execution(in-use=5776, alloc=8088)
kkoqbc: finish optimizing query block SEL$9E43CB6E (#0)
CBRID - frodef: INFL1 queryblock SEL$9E43CB6E blocking operation found.
CBRID - frodef: INFL2 queryblock SEL$9E43CB6E blocking operation found.
CBRID - frodef: INFL2 queryblock SEL$9E43CB6E blocking operation found.
CBRID - frodef: INFL3 queryblock SEL$9E43CB6E blocking operation found.
apadrv-end
:
call(in-use=20072, alloc=98496), compile(in-use=108032, alloc=109616), execution(in-use=5776, alloc=8088)
kkodpAddRwsIdRef: node 0x7f5f725b5d08 with subplan 2 added
kkodpAddRwsIdRef: node 0x7f5f725b5288 with subplan 1 added
kkodpAddRwsIdRef: node 0x7f5f725b5b10 with subplan 2 added
kkodpAddRwsIdRef: node 0x7f5f725b5fb0 with subplan 2 added
kkodpAddRwsIdRef: node 0x7f5f725b5d08 with subplan 2 added
kkodpAddRwsIdRef: node 0x7f5f725b5b10 with subplan 1 added
kkodpAddRwsIdRef: node 0x7f5f725b58a8 with subplan 1 added
kkodpAddRwsIdRef: node 0x7f5f719b2318 with subplan 1 added
kkodpAddRwsIdRef: node 0x7f5f725b5288 with subplan 1 added
kkodpAddRwsIdRef: node 0x7f5f725b5b10 with subplan 65535 added
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=45(MB) time=225(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=45(MB) time=225(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=34(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=34(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=25(MB) time=125(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=25(MB) time=125(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=25(MB) time=125(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=25(MB) time=125(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=34(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=34(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=35(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=35(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=35(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=7(MB) time=35(ms)
Starting SQL statement dump
user_id=111 user_name=RIK module=SQL*Plus action=
sql_id=1vnadspvk62bn plan_hash_value=-1985838147 problem_type=3
----- Current SQL Statement for this session (sql_id=1vnadspvk62bn) -----
SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id)
sql_text_length=77
sql=SELECT count(*)
FROM infl1
JOIN infl2 USING (id)
JOIN infl3 USING (id)
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
---------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
---------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 5771 | |
| 1 | SORT AGGREGATE | | 1 | 18 | | |
| 2 | HASH JOIN | | 827K | 15M | 5771 | 00:01:10 |
| 3 | INDEX FAST FULL SCAN | INFL3_PK| 827K | 4960K | 875 | 00:00:11 |
| 4 | HASH JOIN | | 827K | 9919K | 3208 | 00:00:39 |
| 5 | NESTED LOOPS | | 827K | 9919K | 3208 | 00:00:39 |
| 6 | STATISTICS COLLECTOR | | | | | |
| 7 | INDEX FAST FULL SCAN | INFL1_PK| 827K | 4960K | 875 | 00:00:11 |
| 8 | INDEX UNIQUE SCAN | INFL2_PK| 1 | 6 | 885 | 00:00:11 |
| 9 | INDEX FAST FULL SCAN | INFL2_PK| 827K | 4960K | 885 | 00:00:11 |
---------------------------------------------+-----------------------------------+
Predicate Information:
----------------------
2 - access("INFL2"."ID"="INFL3"."ID")
4 - access("INFL1"."ID"="INFL2"."ID")
8 - access("INFL1"."ID"="INFL2"."ID")
Content of other_xml column
===========================
adaptive_plan : yes
db_version : 12.1.0.1
parse_schema : RIK
plan_hash : 2309129149
plan_hash_2 : 4049313857
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('12.1.0.1')
DB_VERSION('12.1.0.1')
ALL_ROWS
OUTLINE_LEAF(@"SEL$9E43CB6E")
MERGE(@"SEL$58A6D7F6")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$58A6D7F6")
MERGE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$1")
INDEX_FFS(@"SEL$9E43CB6E" "INFL1"@"SEL$1" ("INFL1"."ID"))
INDEX_FFS(@"SEL$9E43CB6E" "INFL2"@"SEL$1" ("INFL2"."ID"))
INDEX_FFS(@"SEL$9E43CB6E" "INFL3"@"SEL$2" ("INFL3"."ID"))
LEADING(@"SEL$9E43CB6E" "INFL1"@"SEL$1" "INFL2"@"SEL$1" "INFL3"@"SEL$2")
USE_HASH(@"SEL$9E43CB6E" "INFL2"@"SEL$1")
USE_HASH(@"SEL$9E43CB6E" "INFL3"@"SEL$2")
SWAP_JOIN_INPUTS(@"SEL$9E43CB6E" "INFL3"@"SEL$2")
END_OUTLINE_DATA
*/
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 12.1.0.1
_optimizer_search_limit = 5
cpu_count = 2
active_instance_count = 1
parallel_threads_per_cpu = 2
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 274432 KB
_pga_max_size = 204800 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 274 KB
_smm_max_size_static = 54886 KB
_smm_px_max_size_static = 137216 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 12.1.0.1
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = true
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = all
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
_optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 80
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 66
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 4
total_cpu_count = 2
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 126
_px_cpu_autodop_enabled = true
parallel_degree_level = 100
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_adaptive_plans = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 200
_use_hidden_partitions = false
_px_monitor_load = false
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 1
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = false
optimizer_adaptive_features = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 3
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_array_cdb_view_enabled = true
Bug Fix Control Environment
fix 3834770 = 1
fix 3746511 = enabled
fix 4519016 = enabled
fix 3118776 = enabled
fix 4488689 = enabled
fix 2194204 = disabled
fix 2660592 = enabled
fix 2320291 = enabled
fix 2324795 = enabled
fix 4308414 = enabled
fix 3499674 = disabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 1403283 = enabled
fix 4554846 = enabled
fix 4602374 = enabled
fix 4584065 = enabled
fix 4545833 = enabled
fix 4611850 = enabled
fix 4663698 = enabled
fix 4663804 = enabled
fix 4666174 = enabled
fix 4567767 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4708389 = enabled
fix 4175830 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 4386734 = enabled
fix 4887636 = enabled
fix 4483240 = enabled
fix 4872602 = disabled
fix 4711525 = enabled
fix 4545802 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 4900129 = enabled
fix 4924149 = enabled
fix 4663702 = enabled
fix 4878299 = enabled
fix 4658342 = enabled
fix 4881533 = enabled
fix 4676955 = enabled
fix 4273361 = enabled
fix 4967068 = enabled
fix 4969880 = disabled
fix 5005866 = enabled
fix 5015557 = enabled
fix 4705343 = enabled
fix 4904838 = enabled
fix 4716096 = enabled
fix 4483286 = disabled
fix 4722900 = enabled
fix 4615392 = enabled
fix 5096560 = enabled
fix 5029464 = enabled
fix 4134994 = enabled
fix 4904890 = enabled
fix 5104624 = enabled
fix 5014836 = enabled
fix 4768040 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 4595987 = enabled
fix 4908162 = enabled
fix 5139520 = enabled
fix 5084239 = enabled
fix 5143477 = disabled
fix 2663857 = enabled
fix 4717546 = enabled
fix 5240264 = disabled
fix 5099909 = enabled
fix 5240607 = enabled
fix 5195882 = enabled
fix 5220356 = enabled
fix 5263572 = enabled
fix 5385629 = enabled
fix 5302124 = enabled
fix 5391942 = enabled
fix 5384335 = enabled
fix 5482831 = enabled
fix 4158812 = enabled
fix 5387148 = enabled
fix 5383891 = enabled
fix 5466973 = enabled
fix 5396162 = enabled
fix 5394888 = enabled
fix 5395291 = enabled
fix 5236908 = enabled
fix 5509293 = enabled
fix 5449488 = enabled
fix 5567933 = enabled
fix 5570494 = enabled
fix 5288623 = enabled
fix 5505995 = enabled
fix 5505157 = enabled
fix 5112460 = enabled
fix 5554865 = enabled
fix 5112260 = enabled
fix 5112352 = enabled
fix 5547058 = enabled
fix 5618040 = enabled
fix 5585313 = enabled
fix 5547895 = enabled
fix 5634346 = enabled
fix 5620485 = enabled
fix 5483301 = enabled
fix 5657044 = enabled
fix 5694984 = enabled
fix 5868490 = enabled
fix 5650477 = enabled
fix 5611962 = enabled
fix 4279274 = enabled
fix 5741121 = enabled
fix 5714944 = enabled
fix 5391505 = enabled
fix 5762598 = enabled
fix 5578791 = enabled
fix 5259048 = enabled
fix 5882954 = enabled
fix 2492766 = enabled
fix 5707608 = enabled
fix 5891471 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5371452 = enabled
fix 5838613 = enabled
fix 5949981 = enabled
fix 5624216 = enabled
fix 5741044 = enabled
fix 5976822 = enabled
fix 6006457 = enabled
fix 5872956 = enabled
fix 5923644 = enabled
fix 5943234 = enabled
fix 5844495 = enabled
fix 4168080 = enabled
fix 6020579 = enabled
fix 5842686 = disabled
fix 5996801 = enabled
fix 5593639 = enabled
fix 6133948 = enabled
fix 3151991 = enabled
fix 6146906 = enabled
fix 6239909 = enabled
fix 6267621 = enabled
fix 5909305 = enabled
fix 6279918 = enabled
fix 6141818 = enabled
fix 6151963 = enabled
fix 6251917 = enabled
fix 6282093 = enabled
fix 6119510 = enabled
fix 6119382 = enabled
fix 3801750 = enabled
fix 5705630 = disabled
fix 5944076 = enabled
fix 5406763 = enabled
fix 6070954 = enabled
fix 6282944 = enabled
fix 6138746 = enabled
fix 6082745 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 6062266 = enabled
fix 6087237 = enabled
fix 6122894 = enabled
fix 6377505 = enabled
fix 5893768 = enabled
fix 6163564 = enabled
fix 6073325 = enabled
fix 6188881 = enabled
fix 6007259 = enabled
fix 6239971 = enabled
fix 5284200 = disabled
fix 6042205 = enabled
fix 6051211 = enabled
fix 6434668 = enabled
fix 6438752 = enabled
fix 5936366 = enabled
fix 6439032 = enabled
fix 6438892 = enabled
fix 6006300 = enabled
fix 5947231 = enabled
fix 5416118 = 1
fix 6365442 = 1
fix 6239039 = enabled
fix 6502845 = enabled
fix 6913094 = enabled
fix 6029469 = enabled
fix 5919513 = enabled
fix 6057611 = enabled
fix 6469667 = enabled
fix 6608941 = disabled
fix 6368066 = enabled
fix 6329318 = enabled
fix 6656356 = enabled
fix 4507997 = enabled
fix 6671155 = enabled
fix 6694548 = enabled
fix 6688200 = enabled
fix 6612471 = enabled
fix 6708183 = disabled
fix 6326934 = enabled
fix 6520717 = disabled
fix 6714199 = enabled
fix 6681545 = enabled
fix 6748058 = enabled
fix 6167716 = enabled
fix 6674254 = enabled
fix 6468287 = enabled
fix 6503543 = enabled
fix 6808773 = disabled
fix 6766962 = enabled
fix 6120483 = enabled
fix 6670551 = enabled
fix 6771838 = enabled
fix 6626018 = disabled
fix 6530596 = enabled
fix 6778642 = enabled
fix 6699059 = enabled
fix 6376551 = enabled
fix 6429113 = enabled
fix 6782437 = enabled
fix 6776808 = enabled
fix 6765823 = enabled
fix 6768660 = enabled
fix 6782665 = enabled
fix 6610822 = enabled
fix 6514189 = enabled
fix 6818410 = enabled
fix 6827696 = enabled
fix 6773613 = enabled
fix 5902962 = enabled
fix 6956212 = enabled
fix 3056297 = enabled
fix 6440977 = disabled
fix 6972291 = disabled
fix 6904146 = enabled
fix 6221403 = enabled
fix 5475051 = enabled
fix 6845871 = enabled
fix 5468809 = enabled
fix 6917633 = enabled
fix 4444536 = disabled
fix 6955210 = enabled
fix 6994194 = enabled
fix 6399597 = disabled
fix 6951776 = enabled
fix 5648287 = 3
fix 6987082 = disabled
fix 7132036 = enabled
fix 6980350 = enabled
fix 5199213 = enabled
fix 7138405 = enabled
fix 7148689 = enabled
fix 6820988 = enabled
fix 7032684 = enabled
fix 6617866 = enabled
fix 7155968 = enabled
fix 7127980 = enabled
fix 6982954 = enabled
fix 7241819 = enabled
fix 6897034 = enabled
fix 7236148 = enabled
fix 7298570 = enabled
fix 7249095 = enabled
fix 7314499 = enabled
fix 7324224 = enabled
fix 7289023 = enabled
fix 7237571 = enabled
fix 7116357 = enabled
fix 7345484 = enabled
fix 7375179 = enabled
fix 6430500 = disabled
fix 5897486 = enabled
fix 6774209 = enabled
fix 7306637 = enabled
fix 6451322 = enabled
fix 7208131 = enabled
fix 7388652 = enabled
fix 7127530 = enabled
fix 6751206 = enabled
fix 6669103 = enabled
fix 7430474 = enabled
fix 6990305 = enabled
fix 7043307 = enabled
fix 3120429 = enabled
fix 7452823 = disabled
fix 6838105 = enabled
fix 6769711 = enabled
fix 7170213 = enabled
fix 6528872 = enabled
fix 7295298 = enabled
fix 5922070 = enabled
fix 7259468 = enabled
fix 6418552 = enabled
fix 4619997 = enabled
fix 7524366 = enabled
fix 6942476 = enabled
fix 6418771 = enabled
fix 7375077 = enabled
fix 5400639 = enabled
fix 4570921 = enabled
fix 7426911 = enabled
fix 5099019 = disabled
fix 7528216 = enabled
fix 7521266 = enabled
fix 7385140 = enabled
fix 7576516 = enabled
fix 7573526 = enabled
fix 7576476 = enabled
fix 7165898 = enabled
fix 7263214 = enabled
fix 3320140 = enabled
fix 7555510 = enabled
fix 7613118 = enabled
fix 7597059 = enabled
fix 7558911 = enabled
fix 5520732 = enabled
fix 7679490 = disabled
fix 7449971 = enabled
fix 3628118 = enabled
fix 4370840 = enabled
fix 7281191 = enabled
fix 7519687 = enabled
fix 5029592 = 3
fix 6012093 = 1
fix 6053861 = disabled
fix 6941515 = disabled
fix 7696414 = enabled
fix 7272039 = enabled
fix 7834811 = enabled
fix 7640597 = enabled
fix 7341616 = enabled
fix 7168184 = enabled
fix 399198 = enabled
fix 7831070 = enabled
fix 7676897 = disabled
fix 7414637 = enabled
fix 7585456 = enabled
fix 8202421 = enabled
fix 7658097 = disabled
fix 8251486 = enabled
fix 7132684 = enabled
fix 7512227 = enabled
fix 6972987 = enabled
fix 7199035 = enabled
fix 8243446 = enabled
fix 7650462 = enabled
fix 6720701 = enabled
fix 7592673 = enabled
fix 7718694 = enabled
fix 7534027 = enabled
fix 7708267 = enabled
fix 5716785 = enabled
fix 7356191 = enabled
fix 7679161 = enabled
fix 7597159 = enabled
fix 7499258 = enabled
fix 8328363 = enabled
fix 7452863 = enabled
fix 8284930 = enabled
fix 7298626 = enabled
fix 7657126 = enabled
fix 8371884 = enabled
fix 8318020 = enabled
fix 8255423 = enabled
fix 7135745 = enabled
fix 8356253 = enabled
fix 7534257 = enabled
fix 8323407 = enabled
fix 7539815 = enabled
fix 8289316 = enabled
fix 8447850 = enabled
fix 7675944 = enabled
fix 8355120 = enabled
fix 7176746 = enabled
fix 8442891 = enabled
fix 8373261 = enabled
fix 7679164 = enabled
fix 7670533 = enabled
fix 8408665 = enabled
fix 8491399 = enabled
fix 8348392 = enabled
fix 8348585 = enabled
fix 8508056 = enabled
fix 8335178 = enabled
fix 8515269 = enabled
fix 8247017 = enabled
fix 7325597 = enabled
fix 8531490 = enabled
fix 6163600 = enabled
fix 8589278 = disabled
fix 8557992 = enabled
fix 7556098 = enabled
fix 8580883 = enabled
fix 5892599 = disabled
fix 8609714 = enabled
fix 8619631 = disabled
fix 8672915 = enabled
fix 8514561 = enabled
fix 8213977 = enabled
fix 8560951 = disabled
fix 8578587 = enabled
fix 8287870 = enabled
fix 8467123 = enabled
fix 8602185 = enabled
fix 8519457 = enabled
fix 3335182 = enabled
fix 8602840 = enabled
fix 8725296 = enabled
fix 8628970 = enabled
fix 6754080 = enabled
fix 8767442 = enabled
fix 8760135 = enabled
fix 8644935 = enabled
fix 8352378 = enabled
fix 8685327 = enabled
fix 8763472 = enabled
fix 8773324 = enabled
fix 8813674 = enabled
fix 8532236 = enabled
fix 8629716 = enabled
fix 7277732 = enabled
fix 8692170 = enabled
fix 8900973 = enabled
fix 8919133 = enabled
fix 8927050 = enabled
fix 8551880 = enabled
fix 8901237 = enabled
fix 8812372 = enabled
fix 6236862 = enabled
fix 8528517 = enabled
fix 7215982 = enabled
fix 8214022 = enabled
fix 8595392 = enabled
fix 8890233 = enabled
fix 8999317 = enabled
fix 9004800 = enabled
fix 8986163 = enabled
fix 8855396 = enabled
fix 8800514 = 20
fix 9007859 = enabled
fix 8198783 = disabled
fix 9053879 = enabled
fix 6086930 = enabled
fix 7641601 = enabled
fix 9052506 = enabled
fix 9103775 = enabled
fix 9047975 = enabled
fix 8893626 = enabled
fix 9111170 = enabled
fix 8971829 = enabled
fix 7628358 = enabled
fix 9125151 = enabled
fix 9039715 = enabled
fix 9106224 = enabled
fix 9185228 = enabled
fix 9206747 = enabled
fix 9088510 = enabled
fix 9143856 = enabled
fix 8833381 = enabled
fix 8949971 = enabled
fix 8951812 = enabled
fix 9148171 = enabled
fix 8706652 = enabled
fix 9245114 = enabled
fix 8802198 = enabled
fix 9011016 = enabled
fix 9265681 = enabled
fix 7284269 = enabled
fix 9272549 = enabled
fix 8917507 = 7
fix 8531463 = enabled
fix 9263333 = enabled
fix 8675087 = enabled
fix 8571403 = enabled
fix 8896955 = enabled
fix 9041934 = enabled
fix 9344709 = enabled
fix 9024933 = enabled
fix 9033718 = enabled
fix 9240455 = enabled
fix 9081848 = enabled
fix 5982893 = enabled
fix 9287401 = enabled
fix 8590021 = enabled
fix 9340120 = enabled
fix 9355794 = enabled
fix 9356656 = enabled
fix 9385634 = enabled
fix 9069046 = enabled
fix 9239337 = enabled
fix 9300228 = enabled
fix 9298010 = enabled
fix 9384170 = enabled
fix 9407929 = enabled
fix 8836806 = enabled
fix 9344055 = enabled
fix 9274675 = enabled
fix 9203723 = enabled
fix 9443476 = enabled
fix 9195582 = enabled
fix 8226666 = enabled
fix 9433490 = enabled
fix 9065494 = enabled
fix 9303766 = enabled
fix 9437283 = enabled
fix 9116214 = enabled
fix 9456688 = enabled
fix 9456746 = disabled
fix 9342979 = enabled
fix 9465425 = enabled
fix 9092442 = enabled
fix 4926618 = enabled
fix 8792846 = enabled
fix 9474259 = enabled
fix 9495669 = disabled
fix 6472966 = enabled
fix 6408301 = enabled
fix 9380298 = disabled
fix 8500130 = enabled
fix 9584723 = enabled
fix 9270951 = enabled
fix 9508254 = enabled
fix 9593680 = enabled
fix 9196440 = disabled
fix 9309281 = enabled
fix 8693158 = enabled
fix 9381638 = enabled
fix 9383967 = enabled
fix 7711900 = enabled
fix 9218587 = enabled
fix 9728438 = enabled
fix 9038395 = enabled
fix 9577300 = enabled
fix 9171113 = enabled
fix 8973745 = enabled
fix 9732434 = enabled
fix 8937971 = disabled
fix 9102474 = enabled
fix 9243499 = enabled
fix 9791810 = enabled
fix 9785632 = enabled
fix 9898249 = enabled
fix 9153459 = enabled
fix 9680430 = enabled
fix 9841679 = enabled
fix 9912503 = enabled
fix 9850461 = enabled
fix 9762592 = 3
fix 9716877 = enabled
fix 9814067 = enabled
fix 9776736 = enabled
fix 8349119 = enabled
fix 9958518 = enabled
fix 10041074 = enabled
fix 10004943 = enabled
fix 9980661 = enabled
fix 9554026 = enabled
fix 9593547 = enabled
fix 9833381 = enabled
fix 10043801 = enabled
fix 9940732 = enabled
fix 9702850 = enabled
fix 9659125 = 0
fix 9668086 = enabled
fix 9476520 = enabled
fix 10158107 = enabled
fix 10148457 = enabled
fix 10106423 = enabled
fix 9721439 = disabled
fix 10162430 = enabled
fix 10134677 = enabled
fix 10182051 = 3
fix 10175079 = enabled
fix 10026972 = enabled
fix 10192889 = enabled
fix 3566843 = enabled
fix 9550277 = disabled
fix 10236566 = enabled
fix 10227392 = enabled
fix 8961143 = enabled
fix 9721228 = enabled
fix 10080014 = enabled
fix 10101489 = enabled
fix 9929609 = enabled
fix 10015652 = enabled
fix 9918661 = enabled
fix 10333395 = enabled
fix 10336499 = disabled
fix 10182672 = enabled
fix 9578670 = enabled
fix 10232225 = enabled
fix 10330090 = enabled
fix 10232623 = enabled
fix 9630092 = disabled
fix 10271790 = enabled
fix 9227576 = enabled
fix 10197666 = enabled
fix 10376744 = enabled
fix 8274946 = enabled
fix 10046368 = enabled
fix 9569678 = enabled
fix 9002661 = enabled
fix 10038373 = enabled
fix 9477688 = enabled
fix 10013899 = enabled
fix 9832338 = enabled
fix 10623119 = enabled
fix 9898066 = enabled
fix 11699884 = enabled
fix 10640430 = enabled
fix 10428450 = enabled
fix 10117760 = enabled
fix 11720178 = enabled
fix 9881812 = enabled
fix 10428278 = enabled
fix 11741436 = enabled
fix 11668189 = enabled
fix 10359631 = enabled
fix 9829887 = enabled
fix 8275054 = enabled
fix 11814428 = enabled
fix 11676888 = disabled
fix 10348427 = enabled
fix 11843512 = enabled
fix 11657468 = enabled
fix 11877160 = enabled
fix 11738631 = enabled
fix 11744086 = enabled
fix 11830663 = enabled
fix 11853331 = enabled
fix 9748015 = enabled
fix 11834739 = enabled
fix 6055658 = enabled
fix 11740670 = enabled
fix 11940126 = enabled
fix 12315002 = enabled
fix 8275023 = enabled
fix 12352373 = enabled
fix 12390139 = enabled
fix 11935589 = enabled
fix 10226906 = enabled
fix 12327548 = enabled
fix 12388221 = enabled
fix 11892888 = enabled
fix 11814265 = enabled
fix 10230017 = enabled
fix 12341619 = enabled
fix 11744016 = enabled
fix 10216738 = enabled
fix 10298302 = enabled
fix 12563419 = enabled
fix 12399886 = enabled
fix 12584007 = enabled
fix 11881047 = enabled
fix 12534597 = enabled
fix 8683604 = enabled
fix 12410972 = enabled
fix 7147087 = enabled
fix 11846314 = enabled
fix 12535474 = enabled
fix 12561635 = enabled
fix 12432426 = enabled
fix 9913117 = enabled
fix 12432089 = enabled
fix 12587690 = enabled
fix 11858963 = enabled
fix 12569245 = enabled
fix 12569300 = enabled
fix 7308975 = disabled
fix 12569316 = enabled
fix 12569321 = enabled
fix 12335617 = enabled
fix 9002958 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix 12313574 = enabled
fix 12569713 = enabled
fix 12348584 = enabled
fix 10420220 = enabled
fix 12559453 = enabled
fix 12727549 = enabled
fix 12728203 = enabled
fix 12828479 = enabled
fix 10181153 = enabled
fix 9971371 = disabled
fix 12864791 = enabled
fix 12810427 = enabled
fix 12605402 = enabled
fix 12914055 = enabled
fix 12861609 = enabled
fix 12915337 = enabled
fix 12942119 = enabled
fix 12622441 = enabled
fix 11072246 = enabled
fix 12739252 = enabled
fix 12953765 = enabled
fix 12905116 = enabled
fix 12978495 = enabled
fix 9633142 = disabled
fix 3639130 = enabled
fix 12827166 = enabled
fix 12944193 = enabled
fix 13020272 = enabled
fix 12673320 = enabled
fix 12975771 = enabled
fix 12882092 = enabled
fix 12379334 = enabled
fix 12723414 = enabled
fix 9488694 = disabled
fix 13255388 = 10
fix 11727871 = enabled
fix 13110511 = enabled
fix 13075297 = enabled
fix 13345888 = enabled
fix 11657903 = disabled
fix 13396096 = enabled
fix 12591379 = enabled
fix 13398214 = enabled
fix 13382280 = enabled
fix 12869367 = enabled
fix 12999577 = enabled
fix 12433153 = enabled
fix 9094254 = enabled
fix 13104618 = enabled
fix 13524237 = enabled
fix 11813257 = enabled
fix 13489017 = enabled
fix 12954320 = enabled
fix 13555551 = enabled
fix 13499154 = enabled
fix 13036910 = enabled
fix 13545925 = enabled
fix 13545956 = enabled
fix 13545989 = enabled
fix 12839247 = enabled
fix 9858777 = enabled
fix 13568366 = enabled
fix 13393357 = enabled
fix 13040171 = enabled
fix 13406619 = enabled
fix 13594757 = enabled
fix 13543207 = enabled
fix 13594712 = enabled
fix 12648629 = enabled
fix 13549808 = enabled
fix 13634700 = enabled
fix 8792821 = enabled
fix 13454409 = enabled
fix 13146487 = enabled
fix 13592248 = enabled
fix 11689541 = enabled
fix 13527374 = enabled
fix 13430622 = enabled
fix 13704562 = enabled
fix 9547706 = enabled
fix 13497184 = enabled
fix 13704977 = enabled
fix 13734456 = enabled
fix 13070532 = enabled
fix 6520878 = enabled
fix 2273284 = enabled
fix 13786127 = enabled
fix 13065064 = enabled
fix 13972896 = enabled
fix 11843466 = enabled
fix 13777823 = enabled
fix 13616573 = enabled
fix 13831671 = enabled
fix 13652216 = enabled
fix 13912192 = enabled
fix 13909909 = enabled
fix 13849486 = enabled
fix 13321547 = enabled
fix 13886606 = disabled
fix 14013502 = enabled
fix 13850256 = enabled
fix 13929275 = enabled
fix 11732303 = enabled
fix 13906168 = enabled
fix 14055128 = enabled
fix 12856200 = enabled
fix 14008590 = enabled
fix 13627489 = disabled
fix 13961105 = enabled
fix 13583722 = enabled
fix 13076238 = enabled
fix 13936229 = enabled
fix 9852856 = enabled
fix 3904125 = enabled
fix 5910187 = enabled
fix 10068316 = enabled
fix 14029891 = enabled
fix 4215125 = enabled
fix 13711083 = enabled
fix 13973691 = enabled
fix 13486825 = enabled
fix 13682550 = enabled
fix 13826669 = enabled
fix 14033181 = enabled
fix 13836796 = enabled
fix 12555499 = enabled
fix 13568506 = enabled
fix 9891396 = enabled
fix 13699643 = enabled
fix 13835788 = enabled
fix 7271518 = enabled
fix 14127824 = enabled
fix 12557401 = enabled
fix 13350470 = enabled
fix 14095362 = enabled
fix 13000118 = enabled
fix 14254795 = enabled
fix 14012261 = enabled
fix 14241953 = enabled
fix 14221012 = enabled
fix 13329748 = enabled
fix 13843964 = enabled
fix 14254052 = enabled
fix 13814866 = enabled
fix 14255600 = disabled
fix 13735304 = enabled
fix 14142884 = disabled
fix 12909121 = enabled
fix 14464068 = enabled
fix 14295250 = 45000
fix 6873091 = enabled
fix 13448445 = enabled
fix 14155722 = enabled
fix 14098180 = enabled
fix 11905801 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 13905599 = disabled
fix 14320077 = enabled
fix 14243782 = enabled
fix 9114915 = enabled
fix 14516175 = enabled
fix 12812697 = enabled
fix 13109345 = enabled
fix 14456124 = enabled
fix 14605040 = enabled
fix 14595273 = disabled
fix 14176247 = enabled
fix 11894476 = enabled
fix 14256885 = enabled
fix 14545269 = enabled
fix 14668404 = disabled
fix 14144611 = enabled
fix 14346182 = enabled
fix 13083139 = enabled
fix 14726188 = enabled
fix 14707009 = enabled
fix 14703133 = enabled
fix 14618560 = enabled
fix 14170552 = enabled
fix 13263174 = enabled
fix 14669785 = enabled
fix 14633570 = enabled
fix 14755138 = enabled
fix 14682092 = enabled
fix 14712222 = enabled
fix 14570575 = enabled
fix 14707748 = disabled
fix 14684079 = disabled
fix 13245379 = enabled
fix 13853916 = enabled
fix 13699007 = enabled
fix 14843189 = enabled
fix 14147762 = enabled
fix 14795969 = enabled
fix 13573073 = enabled
fix 14058291 = disabled
fix 16029607 = enabled
fix 16058481 = enabled
fix 16166364 = enabled
fix 16496848 = disabled
fix 12693573 = enabled
Query Block Registry:
SEL$3 0x719def80 (PARSER)
SEL$9E43CB6E 0x719def80 (VIEW MERGE SEL$3; SEL$58A6D7F6) [FINAL]
SEL$2 0x719d2790 (PARSER)
SEL$58A6D7F6 0x719d2790 (VIEW MERGE SEL$2; SEL$1)
SEL$9E43CB6E 0x719def80 (VIEW MERGE SEL$3; SEL$58A6D7F6) [FINAL]
SEL$1 0x719d7828 (PARSER)
SEL$58A6D7F6 0x719d2790 (VIEW MERGE SEL$2; SEL$1)
...
:
call(in-use=35968, alloc=98496), compile(in-use=160888, alloc=231448), execution(in-use=22848, alloc=24312)
End of Optimizer State Dump
Dumping Hints
=============
====================== END SQL Statement Dump ======================
|