OCEANBASE执行计划： ========================================================================================================================= |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ------------------------------------------------------------------------------------------------------------------------- |0 |SCALAR GROUP BY | |1 |6757559 | |1 |└─SUBPLAN SCAN |VIEW2 |6277667 |6643782 | |2 | └─UNION ALL | |6277667 |6627166 | |3 | ├─HASH JOIN | |3138834 |3032616 | |4 | │ ├─TABLE FULL SCAN |infraSzsm(idx_ftsp_infra_szsm_1)|1255 |22 | |5 | │ └─HASH JOIN | |2982530 |1960724 | |6 | │ ├─HASH OUTER JOIN | |246934 |707013 | |7 | │ │ ├─NESTED-LOOP OUTER JOIN | |100828 |39311 | |8 | │ │ │ ├─NESTED-LOOP OUTER JOIN | |469 |29557 | |9 | │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |286 |23616 | |10| │ │ │ │ │ ├─NESTED-LOOP JOIN | |221 |19026 | |11| │ │ │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |214 |14569 | |12| │ │ │ │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |214 |8235 | |13| │ │ │ │ │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |192 |4235 | |14| │ │ │ │ │ │ │ │ │ ├─MERGE JOIN | |192 |234 | |15| │ │ │ │ │ │ │ │ │ │ ├─SUBPLAN SCAN |VIEW1 |384 |59 | |16| │ │ │ │ │ │ │ │ │ │ │ └─MERGE DISTINCT | |384 |58 | |17| │ │ │ │ │ │ │ │ │ │ │ └─NESTED-LOOP JOIN CARTESIAN | |385 |54 | |18| │ │ │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |pg_(idx_ftsp_kh_pg_3) |384 |15 | |19| │ │ │ │ │ │ │ │ │ │ │ └─MATERIAL | |2 |28 | |20| │ │ │ │ │ │ │ │ │ │ │ └─HASH JOIN | |2 |28 | |21| │ │ │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |yh_(idx_ftsp_zj_bmyh_2) |1 |9 | |22| │ │ │ │ │ │ │ │ │ │ │ └─TABLE RANGE SCAN |bm_(idx_ftsp_zj_bmxx_1) |52 |6 | |23| │ │ │ │ │ │ │ │ │ │ └─NESTED-LOOP JOIN CARTESIAN | |566 |139 | |24| │ │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |kh(idx_ftsp_kh_khxx_13) |1131 |118 | |25| │ │ │ │ │ │ │ │ │ │ └─MATERIAL | |1 |5 | |26| │ │ │ │ │ │ │ │ │ │ └─TABLE GET |zjxx |1 |5 | |27| │ │ │ │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |gsSjqr(uk_ftsp_sb_sbxx_status_1)|1 |21 | |28| │ │ │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |gs(uk_ftsp_sb_khxx_gs_1) |1 |21 | |29| │ │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |cj(ftsp_kh_cjxx_index) |1 |29 | |30| │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |zt(idx_ftsp_zt_ztxx_1) |1 |21 | |31| │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |xtzh(idx_ftsp_kh_dsf_xtzh_1) |1 |21 | |32| │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |sb(uk_ftsp_sb_sbxx) |1 |21 | |33| │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |lzd(uk_ftsp_dj_lzd_1) |1 |21 | |34| │ │ └─TABLE FULL SCAN |jcxx |1924625 |106786 | |35| │ └─TABLE FULL SCAN |szsm |1216196 |650070 | |36| └─HASH JOIN | |3138834 |3577933 | |37| ├─TABLE FULL SCAN |infraSzsm(idx_ftsp_infra_szsm_1)|1255 |22 | |38| └─HASH JOIN | |2982530 |2506041 | |39| ├─HASH OUTER JOIN | |246934 |1252330 | |40| │ ├─HASH RIGHT OUTER JOIN | |100828 |584628 | |41| │ │ ├─TABLE RANGE SCAN |sb(idx_ftsp_sb_sbxx_3) |3100 |12894 | |42| │ │ └─HASH OUTER JOIN | |61379 |548138 | |43| │ │ ├─MERGE OUTER JOIN | |61379 |187902 | |44| │ │ │ ├─NESTED-LOOP OUTER JOIN | |47445 |22309 | |45| │ │ │ │ ├─NESTED-LOOP JOIN | |221 |17720 | |46| │ │ │ │ │ ├─NESTED-LOOP SEMI JOIN | |214 |13262 | |47| │ │ │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |214 |8688 | |48| │ │ │ │ │ │ │ ├─NESTED-LOOP OUTER JOIN | |214 |4234 | |49| │ │ │ │ │ │ │ │ ├─MERGE JOIN | |192 |234 | |50| │ │ │ │ │ │ │ │ │ ├─SUBPLAN SCAN |VIEW1 |384 |59 | |51| │ │ │ │ │ │ │ │ │ │ └─MERGE DISTINCT | |384 |58 | |52| │ │ │ │ │ │ │ │ │ │ └─NESTED-LOOP JOIN CARTESIAN | |385 |54 | |53| │ │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |pg_(idx_ftsp_kh_pg_3) |384 |15 | |54| │ │ │ │ │ │ │ │ │ │ └─MATERIAL | |2 |28 | |55| │ │ │ │ │ │ │ │ │ │ └─HASH JOIN | |2 |28 | |56| │ │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |yh_(idx_ftsp_zj_bmyh_2) |1 |9 | |57| │ │ │ │ │ │ │ │ │ │ └─TABLE RANGE SCAN |bm_(idx_ftsp_zj_bmxx_1) |52 |6 | |58| │ │ │ │ │ │ │ │ │ └─NESTED-LOOP JOIN CARTESIAN | |566 |139 | |59| │ │ │ │ │ │ │ │ │ ├─TABLE RANGE SCAN |kh(idx_ftsp_kh_khxx_13) |1131 |118 | |60| │ │ │ │ │ │ │ │ │ └─MATERIAL | |1 |5 | |61| │ │ │ │ │ │ │ │ │ └─TABLE GET |zjxx |1 |5 | |62| │ │ │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |gs(uk_ftsp_sb_khxx_gs_1) |1 |21 | |63| │ │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |gsSjqr(uk_ftsp_sb_sbxx_status_1)|1 |21 | |64| │ │ │ │ │ │ └─SUBPLAN SCAN |VIEW3 |1 |21 | |65| │ │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |ht(idx_ftsp_ht_htxx_14) |1 |21 | |66| │ │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |zt(idx_ftsp_zt_ztxx_1) |1 |21 | |67| │ │ │ │ └─DISTRIBUTED TABLE RANGE SCAN |lzd(uk_ftsp_dj_lzd_1) |1 |21 | |68| │ │ │ └─TABLE FULL SCAN |xtzh(idx_ftsp_kh_dsf_xtzh_1) |913439 |156596 | |69| │ │ └─TABLE FULL SCAN |cj |1132673 |35962 | |70| │ └─TABLE FULL SCAN |jcxx |1924625 |106786 | |71| └─TABLE FULL SCAN |szsm |1216196 |650070 | ========================================================================================================================= Outputs & filters: ------------------------------------- 0 - output([T_FUN_COUNT(distinct VIEW2.kh.id_(0x7f459815a180))(0x7f4598115510)]), filter(nil), rowset=256 group(nil), agg_func([T_FUN_COUNT(distinct VIEW2.kh.id_(0x7f459815a180))(0x7f4598115510)]) 1 - output([VIEW2.kh.id_(0x7f459815a180)]), filter(nil), rowset=256 access([VIEW2.kh.id_(0x7f459815a180)]) 2 - output([UNION([1])(0x7f42d2c8f460)]), filter(nil), rowset=256 3 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 equal_conds([infraSzsm.smbh_(0x7f42d2c64050) = szsm.infra_szsm_smbh_(0x7f42d2c63a10)(0x7f42d2c74960)]), other_conds([IFNULL(cast(jcxx.swzxh_(0x7f42d2c66be0), VARCHAR(4))(0x7f42d2c79300), '0')(0x7f42d2c78a20) = '0'(0x7f42d2c78120) OR IFNULL(cj.ycqj_(0x7f42d2c67220), '210001')(0x7f42d2c7a770) > '202403'(0x7f42d2c79ea0)(0x7f42d2c77830)]) 4 - output([infraSzsm.smbh_(0x7f42d2c64050)]), filter(nil), rowset=256 access([infraSzsm.smbh_(0x7f42d2c64050)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([infraSzsm.smbh_(0x7f42d2c64050)], [infraSzsm.id_(0x7f42d2c63d30)]), range(MIN,MIN ; MAX,MAX)always true 5 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)], [jcxx.swzxh_(0x7f42d2c66be0)], [szsm.infra_szsm_smbh_(0x7f42d2c63a10)]), filter(nil), rowset=256 equal_conds([szsm.kh_khxx_id_(0x7f42d2c633d0) = kh.id_(0x7f42d2c53840)(0x7f42d2c75230)]), other_conds(nil) 6 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)], [jcxx.swzxh_(0x7f42d2c66be0)]), filter(nil), rowset=256 equal_conds([jcxx.kh_khxx_id_(0x7f42d2c5b580) = kh.id_(0x7f42d2c53840)(0x7f42d2c5acb0)]), other_conds(nil) 7 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:11)]), use_batch=false 8 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:7)]), use_batch=false 9 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:12)]), use_batch=false 10 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:2)]), use_batch=false 11 - output([kh.id_(0x7f42d2c53840)], [cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:9)]), use_batch=false 12 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:6)]), use_batch=false 13 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c53840)(:10)]), use_batch=false 14 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 equal_conds([kh.id_(0x7f42d2c53840) = VIEW1.kh_khxx_id_(0x7f42d2c67ea0)(0x7f42d2c74090)]), other_conds(nil) merge_directions([ASC]) 15 - output([VIEW1.kh_khxx_id_(0x7f42d2c67ea0)]), filter(nil), rowset=256 access([VIEW1.kh_khxx_id_(0x7f42d2c67ea0)]) 16 - output([pg_.kh_khxx_id_(0x7f42d2c80d70)]), filter(nil), rowset=256 distinct([pg_.kh_khxx_id_(0x7f42d2c80d70)]) 17 - output([pg_.kh_khxx_id_(0x7f42d2c80d70)]), filter(nil), rowset=256 conds(nil), nl_params_(nil), use_batch=false 18 - output([pg_.kh_khxx_id_(0x7f42d2c80d70)]), filter(nil), rowset=256 access([pg_.kh_khxx_id_(0x7f42d2c80d70)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([pg_.infra_user_id_(0x7f42d2c7fab0)], [pg_.kh_khxx_id_(0x7f42d2c80d70)], [pg_.create_date_(0x7f46841e5bb0)], [pg_.id_(0x7f42d2c7f150)]), range(h0000000000000399057290070958080,MIN,MIN,MIN ; h0000000000000399057290070958080,MAX,MAX,MAX), range_cond([pg_.infra_user_id_(0x7f42d2c7fab0) = 'h0000000000000399057290070958080'(0x7f42d2c83c10)]) 19 - output(nil), filter(nil), rowset=256 20 - output(nil), filter(nil), rowset=256 equal_conds([yh_.zj_bmxx_id_(0x7f42d2c800f0) = bm_.id_(0x7f42d2c7f790)(0x7f42d2c81c20)]), other_conds(nil) 21 - output([yh_.zj_bmxx_id_(0x7f42d2c800f0)]), filter(nil), rowset=256 access([yh_.id_(0x7f42d2c7f470)], [yh_.zj_bmxx_id_(0x7f42d2c800f0)]), partitions(p0) is_index_back=true, is_global_index=false, range_key([yh_.infra_user_id_(0x7f42d2c7fdd0)], [yh_.is_delete_(0x7f42d2c80730)], [yh_.is_active_(0x7f42d2c80410)], [yh_.id_(0x7f42d2c7f470)]), range(h0000000000000399057290070958080, 0,1,MIN ; h0000000000000399057290070958080,0,1,MAX), range_cond(['h0000000000000399057290070958080' = yh_.infra_user_id_(0x7f42d2c7fdd0)(0x7f456a81b900)], [yh_.is_active_(0x7f42d2c80410) = 1(0x7f456a81c490)], [yh_.is_delete_(0x7f42d2c80730) = 0(0x7f456a81d020)]) 22 - output([bm_.id_(0x7f42d2c7f790)]), filter(nil), rowset=256 access([bm_.id_(0x7f42d2c7f790)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([bm_.zj_zjxx_id_(0x7f42d2c80a50)], [bm_.dept_no_(0x7f450a00d920)], [bm_.id_(0x7f42d2c7f790)]), range(h0000000000000498723430515097600,MIN, MIN ; h0000000000000498723430515097600,MAX,MAX), range_cond([bm_.zj_zjxx_id_(0x7f42d2c80a50) = 'h0000000000000498723430515097600'(0x7f42d2c844e0)]) 23 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 conds(nil), nl_params_(nil), use_batch=false 24 - output([kh.id_(0x7f42d2c53840)]), filter(nil), rowset=256 access([kh.id_(0x7f42d2c53840)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([kh.zj_zjxx_id_(0x7f42d2c61490)], [kh.is_delete_(0x7f42d2c61ad0)], [kh.fw_status_(0x7f42d2c617b0)], [kh.ht_fw_zt_(0x7f42d2c61df0)], [kh.id_(0x7f42d2c53840)]), range(h0000000000000498723430515097600,0,1,1,MIN ; h0000000000000498723430515097600,0,1,1,MAX), range_cond([cast(kh.fw_status_(0x7f42d2c617b0), DECIMAL(4, 0))(0x7f42d2c6b780) = cast('1', DECIMAL(1, -1))(0x7f42d2c6c320)(0x7f42d2c6ae80)], [cast(kh.is_delete_(0x7f42d2c61ad0), DECIMAL(4, 0))(0x7f42d2c6da80) = cast('0', DECIMAL(1, -1))(0x7f42d2c6e620)(0x7f42d2c6d180)], [cast(kh.ht_fw_zt_(0x7f42d2c61df0), DECIMAL(4, 0))(0x7f42d2c6fd80) = cast('1', DECIMAL(1, -1))(0x7f42d2c70920)(0x7f42d2c6f480)], [kh.zj_zjxx_id_(0x7f42d2c61490) = 'h0000000000000498723430515097600'(0x7f42d2c73500)]) 25 - output(nil), filter(nil), rowset=256 26 - output(nil), filter([cast(zjxx.approval_account_(0x7f42d2c62d90), DECIMAL(4, 0))(0x7f42d2c7c4d0) = cast('0', DECIMAL(1, -1))(0x7f42d2c7d070)(0x7f42d2c7bbd0)]), rowset=256 access([zjxx.approval_account_(0x7f42d2c62d90)]), partitions(p0) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([zjxx.id_(0x7f42d2c62a70)]), range[h0000000000000498723430515097600 ; h0000000000000498723430515097600], range_cond([zjxx.id_(0x7f42d2c62a70) = 'h0000000000000498723430515097600'(0x7f456a81dbb0)]) 27 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([gsSjqr.kh_khxx_id_(0x7f42d2c57840)], [gsSjqr.ss_qj_(0x7f42d2c58430)], [gsSjqr.bb_code_(0x7f42d2c59020)], [gsSjqr.hdlx_code_(0x7f4684178940)], [gsSjqr.shadow_pk_0(0x7f4684178c60)]), range(MIN ; MAX), range_cond([gsSjqr.ss_qj_(0x7f42d2c58430) = '202403'(0x7f42d2c57b60)], [gsSjqr.bb_code_(0x7f42d2c59020) = '50003001'(0x7f42d2c58750)], [gsSjqr.kh_khxx_id_(0x7f42d2c57840) = :10(0x7f450a160e20)]) 28 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([gs.kh_khxx_id_(0x7f42d2c5f000)], [gs.kj_qj_(0x7f42d2c5fbf0)], [gs.shadow_pk_0(0x7f468414d6b0)]), range(MIN ; MAX), range_cond([gs.kj_qj_(0x7f42d2c5fbf0) = '202403'(0x7f42d2c5f320)], [gs.kh_khxx_id_(0x7f42d2c5f000) = :6(0x7f450a11e430)]) 29 - output([cj.ycqj_(0x7f42d2c67220)]), filter(nil), rowset=256 access([cj.id_(0x7f42d2c66f00)], [cj.ycqj_(0x7f42d2c67220)]), partitions(p0) is_index_back=true, is_global_index=false, range_key([cj.kh_khxx_id_(0x7f42d2c5a430)], [cj.shadow_pk_0(0x7f468416f180)]), range(MIN ; MAX), range_cond([cj.kh_khxx_id_(0x7f42d2c5a430) = :9(0x7f456a81e740)]) 30 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([zt.kh_khxx_id_(0x7f42d2c62430)], [zt.is_default_(0x7f42d2c62750)], [zt.id_(0x7f42d2c62110)]), range(MIN ; MAX), range_cond([cast(zt.is_default_(0x7f42d2c62750), DECIMAL(1, 0))(0x7f42d2c71dc0) = cast('1', DECIMAL(1, -1))(0x7f42d2c72960)(0x7f42d2c714c0)], [:2 = zt.kh_khxx_id_(0x7f42d2c62430)(0x7f450a090a90)]) 31 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([xtzh.kh_khxx_id_(0x7f42d2c53520)], [xtzh.xtlx_code_(0x7f42d2c54430)], [xtzh.id_(0x7f42d2c67b80)]), range(MIN ; MAX), range_cond([xtzh.xtlx_code_(0x7f42d2c54430) = '04'(0x7f42d2c53b60)], [xtzh.kh_khxx_id_(0x7f42d2c53520) = :12(0x7f450a19ba50)]) 32 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([sb.kh_khxx_id_(0x7f42d2c5c6d0)], [sb.ss_qj_(0x7f42d2c5d2c0)], [sb.bb_code_(0x7f42d2c5deb0)], [sb.shadow_pk_0(0x7f4684156d40)]), range(MIN ; MAX), range_cond([sb.ss_qj_(0x7f42d2c5d2c0) = '202403'(0x7f42d2c5c9f0)], [sb.bb_code_(0x7f42d2c5deb0) = '50003001'(0x7f42d2c5d5e0)], [sb.kh_khxx_id_(0x7f42d2c5c6d0) = :7(0x7f450a130050)]) 33 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([lzd.kh_khxx_id_(0x7f42d2c55840)], [lzd.kj_qj_(0x7f42d2c56430)], [lzd.shadow_pk_0(0x7f468418c710)]), range(MIN ; MAX), range_cond([lzd.kj_qj_(0x7f42d2c56430) = '202403'(0x7f42d2c55b60)], [lzd.kh_khxx_id_(0x7f42d2c55840) = :11(0x7f450a18b6e0)]) 34 - output([jcxx.kh_khxx_id_(0x7f42d2c5b580)], [jcxx.swzxh_(0x7f42d2c66be0)]), filter(nil), rowset=256 access([jcxx.kh_khxx_id_(0x7f42d2c5b580)], [jcxx.swzxh_(0x7f42d2c66be0)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([jcxx.id_(0x7f42d2c668c0)]), range(MIN ; MAX)always true 35 - output([szsm.kh_khxx_id_(0x7f42d2c633d0)], [szsm.infra_szsm_smbh_(0x7f42d2c63a10)]), filter([szsm.szlx_code_(0x7f42d2c636f0) = '06'(0x7f42d2c75b00)]), rowset=256 access([szsm.kh_khxx_id_(0x7f42d2c633d0)], [szsm.szlx_code_(0x7f42d2c636f0)], [szsm.infra_szsm_smbh_(0x7f42d2c63a10)]), partitions(p0) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([szsm.id_(0x7f42d2c630b0)]), range(MIN ; MAX)always true 36 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 equal_conds([infraSzsm.smbh_(0x7f42d2c287a0) = szsm.infra_szsm_smbh_(0x7f42d2c28160)(0x7f42d2c390b0)]), other_conds([IFNULL(cast(jcxx.swzxh_(0x7f42d2c2b330), VARCHAR(4))(0x7f42d2c3da50), '0')(0x7f42d2c3d170) = '0'(0x7f42d2c3c870) OR IFNULL(cj.ycqj_(0x7f42d2c2b970), '210001')(0x7f42d2c3eec0) > '202403'(0x7f42d2c3e5f0)(0x7f42d2c3bf80)]) 37 - output([infraSzsm.smbh_(0x7f42d2c287a0)]), filter(nil), rowset=256 access([infraSzsm.smbh_(0x7f42d2c287a0)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([infraSzsm.smbh_(0x7f42d2c287a0)], [infraSzsm.id_(0x7f42d2c28480)]), range(MIN,MIN ; MAX,MAX)always true 38 - output([kh.id_(0x7f42d2c17f90)], [cj.ycqj_(0x7f42d2c2b970)], [jcxx.swzxh_(0x7f42d2c2b330)], [szsm.infra_szsm_smbh_(0x7f42d2c28160)]), filter(nil), rowset=256 equal_conds([szsm.kh_khxx_id_(0x7f42d2c27b20) = kh.id_(0x7f42d2c17f90)(0x7f42d2c39980)]), other_conds(nil) 39 - output([kh.id_(0x7f42d2c17f90)], [cj.ycqj_(0x7f42d2c2b970)], [jcxx.swzxh_(0x7f42d2c2b330)]), filter(nil), rowset=256 equal_conds([jcxx.kh_khxx_id_(0x7f42d2c1fcd0) = kh.id_(0x7f42d2c17f90)(0x7f42d2c1f400)]), other_conds(nil) 40 - output([kh.id_(0x7f42d2c17f90)], [cj.ycqj_(0x7f42d2c2b970)]), filter(nil), rowset=256 equal_conds([sb.kh_khxx_id_(0x7f42d2c20e20) = kh.id_(0x7f42d2c17f90)(0x7f42d2c20550)]), other_conds(nil) 41 - output([sb.kh_khxx_id_(0x7f42d2c20e20)]), filter(nil), rowset=256 access([sb.id_(0x7f42d2c2acf0)], [sb.kh_khxx_id_(0x7f42d2c20e20)]), partitions(p0) is_index_back=true, is_global_index=false, range_key([sb.ss_qj_(0x7f42d2c21a10)], [sb.bb_code_(0x7f42d2c22600)], [sb.sbsjyc_(0x7f43dad60a90)], [sb.id_(0x7f42d2c2acf0)]), range(202403,50003001, MIN,MIN ; 202403,50003001,MAX,MAX), range_cond([sb.ss_qj_(0x7f42d2c21a10) = '202403'(0x7f456a81f010)], [sb.bb_code_(0x7f42d2c22600) = '50003001'(0x7f456a81fbd0)]) 42 - output([kh.id_(0x7f42d2c17f90)], [cj.ycqj_(0x7f42d2c2b970)]), filter(nil), rowset=256 equal_conds([cj.kh_khxx_id_(0x7f42d2c1eb80) = kh.id_(0x7f42d2c17f90)(0x7f42d2c1e2b0)]), other_conds(nil) 43 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 equal_conds([xtzh.kh_khxx_id_(0x7f42d2c17c70) = kh.id_(0x7f42d2c17f90)(0x7f42d2c173a0)]), other_conds(nil) merge_directions([ASC]) 44 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c17f90)(:43)]), use_batch=false 45 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c17f90)(:34)]), use_batch=false 46 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c17f90)(:49)]), use_batch=false 47 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c17f90)(:42)]), use_batch=false 48 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_([kh.id_(0x7f42d2c17f90)(:38)]), use_batch=false 49 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 equal_conds([kh.id_(0x7f42d2c17f90) = VIEW1.kh_khxx_id_(0x7f42d2c2c5f0)(0x7f42d2c387e0)]), other_conds(nil) merge_directions([ASC]) 50 - output([VIEW1.kh_khxx_id_(0x7f42d2c2c5f0)]), filter(nil), rowset=256 access([VIEW1.kh_khxx_id_(0x7f42d2c2c5f0)]) 51 - output([pg_.kh_khxx_id_(0x7f42d2c454c0)]), filter(nil), rowset=256 distinct([pg_.kh_khxx_id_(0x7f42d2c454c0)]) 52 - output([pg_.kh_khxx_id_(0x7f42d2c454c0)]), filter(nil), rowset=256 conds(nil), nl_params_(nil), use_batch=false 53 - output([pg_.kh_khxx_id_(0x7f42d2c454c0)]), filter(nil), rowset=256 access([pg_.kh_khxx_id_(0x7f42d2c454c0)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([pg_.infra_user_id_(0x7f42d2c44200)], [pg_.kh_khxx_id_(0x7f42d2c454c0)], [pg_.create_date_(0x7f43daded590)], [pg_.id_(0x7f42d2c438a0)]), range(h0000000000000399057290070958080,MIN,MIN,MIN ; h0000000000000399057290070958080,MAX,MAX,MAX), range_cond([pg_.infra_user_id_(0x7f42d2c44200) = 'h0000000000000399057290070958080'(0x7f42d2c48360)]) 54 - output(nil), filter(nil), rowset=256 55 - output(nil), filter(nil), rowset=256 equal_conds([yh_.zj_bmxx_id_(0x7f42d2c44840) = bm_.id_(0x7f42d2c43ee0)(0x7f42d2c46370)]), other_conds(nil) 56 - output([yh_.zj_bmxx_id_(0x7f42d2c44840)]), filter(nil), rowset=256 access([yh_.id_(0x7f42d2c43bc0)], [yh_.zj_bmxx_id_(0x7f42d2c44840)]), partitions(p0) is_index_back=true, is_global_index=false, range_key([yh_.infra_user_id_(0x7f42d2c44520)], [yh_.is_delete_(0x7f42d2c44e80)], [yh_.is_active_(0x7f42d2c44b60)], [yh_.id_(0x7f42d2c43bc0)]), range(h0000000000000399057290070958080, 0,1,MIN ; h0000000000000399057290070958080,0,1,MAX), range_cond(['h0000000000000399057290070958080' = yh_.infra_user_id_(0x7f42d2c44520)(0x7f456a820760)], [yh_.is_active_(0x7f42d2c44b60) = 1(0x7f456a8212f0)], [yh_.is_delete_(0x7f42d2c44e80) = 0(0x7f456a821e80)]) 57 - output([bm_.id_(0x7f42d2c43ee0)]), filter(nil), rowset=256 access([bm_.id_(0x7f42d2c43ee0)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([bm_.zj_zjxx_id_(0x7f42d2c451a0)], [bm_.dept_no_(0x7f4478e156c0)], [bm_.id_(0x7f42d2c43ee0)]), range(h0000000000000498723430515097600,MIN, MIN ; h0000000000000498723430515097600,MAX,MAX), range_cond([bm_.zj_zjxx_id_(0x7f42d2c451a0) = 'h0000000000000498723430515097600'(0x7f42d2c48c30)]) 58 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 conds(nil), nl_params_(nil), use_batch=false 59 - output([kh.id_(0x7f42d2c17f90)]), filter(nil), rowset=256 access([kh.id_(0x7f42d2c17f90)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([kh.zj_zjxx_id_(0x7f42d2c25be0)], [kh.is_delete_(0x7f42d2c26220)], [kh.fw_status_(0x7f42d2c25f00)], [kh.ht_fw_zt_(0x7f42d2c26540)], [kh.id_(0x7f42d2c17f90)]), range(h0000000000000498723430515097600,0,1,1,MIN ; h0000000000000498723430515097600,0,1,1,MAX), range_cond([cast(kh.fw_status_(0x7f42d2c25f00), DECIMAL(4, 0))(0x7f42d2c2fed0) = cast('1', DECIMAL(1, -1))(0x7f42d2c30a70)(0x7f42d2c2f5d0)], [cast(kh.is_delete_(0x7f42d2c26220), DECIMAL(4, 0))(0x7f42d2c321d0) = cast('0', DECIMAL(1, -1))(0x7f42d2c32d70)(0x7f42d2c318d0)], [cast(kh.ht_fw_zt_(0x7f42d2c26540), DECIMAL(4, 0))(0x7f42d2c344d0) = cast('1', DECIMAL(1, -1))(0x7f42d2c35070)(0x7f42d2c33bd0)], [kh.zj_zjxx_id_(0x7f42d2c25be0) = 'h0000000000000498723430515097600'(0x7f42d2c37c50)]) 60 - output(nil), filter(nil), rowset=256 61 - output(nil), filter([lnnvl(cast(cast(zjxx.approval_account_(0x7f42d2c274e0), DECIMAL(4, 0))(0x7f42d2c40c20) = cast('0', DECIMAL(1, -1))(0x7f42d2c417c0)(0x7f42d2c40320), TINYINT(-1, 0))(0x7f42d2c8dd80))(0x7f42d2c8b770)]), rowset=256 access([zjxx.approval_account_(0x7f42d2c274e0)]), partitions(p0) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([zjxx.id_(0x7f42d2c271c0)]), range[h0000000000000498723430515097600 ; h0000000000000498723430515097600], range_cond([zjxx.id_(0x7f42d2c271c0) = 'h0000000000000498723430515097600'(0x7f456a822a10)]) 62 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([gs.kh_khxx_id_(0x7f42d2c23750)], [gs.kj_qj_(0x7f42d2c24340)], [gs.shadow_pk_0(0x7f43dad56fa0)]), range(MIN ; MAX), range_cond([gs.kj_qj_(0x7f42d2c24340) = '202403'(0x7f42d2c23a70)], [gs.kh_khxx_id_(0x7f42d2c23750) = :38(0x7f4478fb0000)]) 63 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([gsSjqr.kh_khxx_id_(0x7f42d2c1bf90)], [gsSjqr.ss_qj_(0x7f42d2c1cb80)], [gsSjqr.bb_code_(0x7f42d2c1d770)], [gsSjqr.hdlx_code_(0x7f43dad80320)], [gsSjqr.shadow_pk_0(0x7f43dad80640)]), range(MIN ; MAX), range_cond([gsSjqr.ss_qj_(0x7f42d2c1cb80) = '202403'(0x7f42d2c1c2b0)], [gsSjqr.bb_code_(0x7f42d2c1d770) = '50003001'(0x7f42d2c1cea0)], [gsSjqr.kh_khxx_id_(0x7f42d2c1bf90) = :42(0x7f4478ff29f0)]) 64 - output(nil), filter(nil), rowset=256 access(nil) 65 - output([ht.kh_khxx_id_(0x7f42d2c4a140)]), filter([ht.status_(0x7f42d2c4a460) = '4'(0x7f42d2c4b690)], ['202403' >= ht.fwqx_q_(0x7f42d2c4a780)(0x7f42d2c4c220)]), rowset=256 access([ht.id_(0x7f42d2c49e20)], [ht.kh_khxx_id_(0x7f42d2c4a140)], [ht.status_(0x7f42d2c4a460)], [ht.fwqx_q_(0x7f42d2c4a780)]), partitions(p0) is_index_back=true, is_global_index=false, filter_before_indexback[true,false], range_key([ht.kh_khxx_id_(0x7f42d2c4a140)], [ht.fwqx_z_(0x7f42d2c4aaa0)], [ht.status_(0x7f42d2c4a460)], [ht.htlx_(0x7f45361ac500)], [ht.id_(0x7f42d2c49e20)]), range(MIN,MIN,MIN,MIN,MIN ; MAX,MAX,MAX,MAX,MAX)always true, range_cond([ht.fwqx_z_(0x7f42d2c4aaa0) >= '202403'(0x7f456a8235a0)], [ht.kh_khxx_id_(0x7f42d2c4a140) = :49(0x7f456a824130)]) 66 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([zt.kh_khxx_id_(0x7f42d2c26b80)], [zt.is_default_(0x7f42d2c26ea0)], [zt.id_(0x7f42d2c26860)]), range(MIN ; MAX), range_cond([cast(zt.is_default_(0x7f42d2c26ea0), DECIMAL(1, 0))(0x7f42d2c36510) = cast('1', DECIMAL(1, -1))(0x7f42d2c370b0)(0x7f42d2c35c10)], [:34 = zt.kh_khxx_id_(0x7f42d2c26b80)(0x7f4478f22640)]) 67 - output(nil), filter(nil), rowset=256 access(nil), partitions(p0) is_index_back=false, is_global_index=false, range_key([lzd.kh_khxx_id_(0x7f42d2c19f90)], [lzd.kj_qj_(0x7f42d2c1ab80)], [lzd.shadow_pk_0(0x7f43dad940f0)]), range(MIN ; MAX), range_cond([lzd.kj_qj_(0x7f42d2c1ab80) = '202403'(0x7f42d2c1a2b0)], [lzd.kh_khxx_id_(0x7f42d2c19f90) = :43(0x7f4536021bf0)]) 68 - output([xtzh.kh_khxx_id_(0x7f42d2c17c70)]), filter([xtzh.xtlx_code_(0x7f42d2c18b80) = '04'(0x7f42d2c182b0)]), rowset=256 access([xtzh.kh_khxx_id_(0x7f42d2c17c70)], [xtzh.xtlx_code_(0x7f42d2c18b80)]), partitions(p0) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([xtzh.kh_khxx_id_(0x7f42d2c17c70)], [xtzh.xtlx_code_(0x7f42d2c18b80)], [xtzh.id_(0x7f42d2c2c2d0)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true 69 - output([cj.kh_khxx_id_(0x7f42d2c1eb80)], [cj.ycqj_(0x7f42d2c2b970)]), filter(nil), rowset=256 access([cj.kh_khxx_id_(0x7f42d2c1eb80)], [cj.ycqj_(0x7f42d2c2b970)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([cj.id_(0x7f42d2c2b650)]), range(MIN ; MAX)always true 70 - output([jcxx.kh_khxx_id_(0x7f42d2c1fcd0)], [jcxx.swzxh_(0x7f42d2c2b330)]), filter(nil), rowset=256 access([jcxx.kh_khxx_id_(0x7f42d2c1fcd0)], [jcxx.swzxh_(0x7f42d2c2b330)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([jcxx.id_(0x7f42d2c2b010)]), range(MIN ; MAX)always true 71 - output([szsm.kh_khxx_id_(0x7f42d2c27b20)], [szsm.infra_szsm_smbh_(0x7f42d2c28160)]), filter([szsm.szlx_code_(0x7f42d2c27e40) = '06'(0x7f42d2c3a250)]), rowset=256 access([szsm.kh_khxx_id_(0x7f42d2c27b20)], [szsm.szlx_code_(0x7f42d2c27e40)], [szsm.infra_szsm_smbh_(0x7f42d2c28160)]), partitions(p0) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([szsm.id_(0x7f42d2c27800)]), range(MIN ; MAX)always true Used Hint: ------------------------------------- /*+ */ Qb name trace: ------------------------------------- stmt_id:0, stmt_type:T_EXPLAIN stmt_id:1, SEL$1 > SEL$7610D21F > SEL$67070354 > SEL$656D0309 > SEL$B2120FD3 > SEL$B7F83611 > SEL$C7155D0D stmt_id:2, SEL$2 stmt_id:3, SEL$3 > SEL$9404CA0D stmt_id:4, parent:SEL$B7F83611 > SEL$62E9F874 stmt_id:5, parent:SEL$62E9F874 > SEL$5CBA7859_1 stmt_id:6, parent:SEL$9404CA0D > SEL$C79BEC53_2 stmt_id:7, parent:SEL$2 > SEL$DE41DCE6_2 stmt_id:8, parent:SEL$62E9F874 > SEL$5CBA7859_2 > SEL$870E47C6 stmt_id:9, parent:SEL$9404CA0D > SEL$C79BEC53_3 stmt_id:10, parent:SEL$2 > SEL$DE41DCE6_3 stmt_id:11, parent:SEL$B7F83611 > SET$C7155D0D Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA LEADING(@"SEL$5CBA7859_1" ("satp_test"."infraSzsm"@"SEL$5CBA7859_1" (((((((((("VIEW1"@"SEL$5CBA7859_1" ("satp_test"."kh"@"SEL$5CBA7859_1" "satp_test"."zjxx"@"SEL$5CBA7859_1")) "satp_test"."gsSjqr"@"SEL$5CBA7859_1") "satp_test"."gs"@"SEL$5CBA7859_1") "satp_test"."cj"@"SEL$5CBA7859_1") "satp_test"."zt"@"SEL$5CBA7859_1") "satp_test"."xtzh"@"SEL$5CBA7859_1") "satp_test"."sb"@"SEL$5CBA7859_1") "satp_test"."lzd"@"SEL$5CBA7859_1") "satp_test"."jcxx"@"SEL$5CBA7859_1") "satp_test"."szsm"@"SEL$5CBA7859_1"))) USE_HASH(@"SEL$5CBA7859_1" ("satp_test"."zt"@"SEL$5CBA7859_1" "satp_test"."zjxx"@"SEL$5CBA7859_1" "satp_test"."xtzh"@"SEL$5CBA7859_1" "satp_test"."szsm"@"SEL$5CBA7859_1" "satp_test"."sb"@"SEL$5CBA7859_1" "satp_test"."lzd"@"SEL$5CBA7859_1" "satp_test"."kh"@"SEL$5CBA7859_1" "satp_test"."jcxx"@"SEL$5CBA7859_1" "satp_test"."gsSjqr"@"SEL$5CBA7859_1" "satp_test"."gs"@"SEL$5CBA7859_1" "satp_test"."cj"@"SEL$5CBA7859_1" "VIEW1"@"SEL$5CBA7859_1")) INDEX(@"SEL$5CBA7859_1" "infraSzsm"@"SEL$5CBA7859_1" "idx_ftsp_infra_szsm_1") USE_HASH(@"SEL$5CBA7859_1" "satp_test"."szsm"@"SEL$5CBA7859_1") USE_HASH(@"SEL$5CBA7859_1" "satp_test"."jcxx"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."lzd"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."sb"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."xtzh"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."zt"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."cj"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."gs"@"SEL$5CBA7859_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."gsSjqr"@"SEL$5CBA7859_1") USE_MERGE(@"SEL$5CBA7859_1" ("satp_test"."zjxx"@"SEL$5CBA7859_1" "satp_test"."kh"@"SEL$5CBA7859_1")) LEADING(@"SEL$C79BEC53_2" ("satp_test"."pg_"@"SEL$C79BEC53_2" ("satp_test"."yh_"@"SEL$C79BEC53_2" "satp_test"."bm_"@"SEL$C79BEC53_2"))) USE_NL(@"SEL$C79BEC53_2" ("satp_test"."yh_"@"SEL$C79BEC53_2" "satp_test"."bm_"@"SEL$C79BEC53_2")) USE_NL_MATERIALIZATION(@"SEL$C79BEC53_2" ("satp_test"."yh_"@"SEL$C79BEC53_2" "satp_test"."bm_"@"SEL$C79BEC53_2")) INDEX(@"SEL$C79BEC53_2" "pg_"@"SEL$C79BEC53_2" "idx_ftsp_kh_pg_3") USE_HASH(@"SEL$C79BEC53_2" "satp_test"."bm_"@"SEL$C79BEC53_2") INDEX(@"SEL$C79BEC53_2" "yh_"@"SEL$C79BEC53_2" "idx_ftsp_zj_bmyh_2") INDEX(@"SEL$C79BEC53_2" "bm_"@"SEL$C79BEC53_2" "idx_ftsp_zj_bmxx_1") USE_NL(@"SEL$5CBA7859_1" "satp_test"."zjxx"@"SEL$5CBA7859_1") USE_NL_MATERIALIZATION(@"SEL$5CBA7859_1" "satp_test"."zjxx"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "kh"@"SEL$5CBA7859_1" "idx_ftsp_kh_khxx_13") FULL(@"SEL$5CBA7859_1" "zjxx"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "gsSjqr"@"SEL$5CBA7859_1" "uk_ftsp_sb_sbxx_status_1") USE_DAS(@"SEL$5CBA7859_1" "gsSjqr"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "gs"@"SEL$5CBA7859_1" "uk_ftsp_sb_khxx_gs_1") USE_DAS(@"SEL$5CBA7859_1" "gs"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "cj"@"SEL$5CBA7859_1" "ftsp_kh_cjxx_index") USE_DAS(@"SEL$5CBA7859_1" "cj"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "zt"@"SEL$5CBA7859_1" "idx_ftsp_zt_ztxx_1") USE_DAS(@"SEL$5CBA7859_1" "zt"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "xtzh"@"SEL$5CBA7859_1" "idx_ftsp_kh_dsf_xtzh_1") USE_DAS(@"SEL$5CBA7859_1" "xtzh"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "sb"@"SEL$5CBA7859_1" "uk_ftsp_sb_sbxx") USE_DAS(@"SEL$5CBA7859_1" "sb"@"SEL$5CBA7859_1") INDEX(@"SEL$5CBA7859_1" "lzd"@"SEL$5CBA7859_1" "uk_ftsp_dj_lzd_1") USE_DAS(@"SEL$5CBA7859_1" "lzd"@"SEL$5CBA7859_1") FULL(@"SEL$5CBA7859_1" "jcxx"@"SEL$5CBA7859_1") FULL(@"SEL$5CBA7859_1" "szsm"@"SEL$5CBA7859_1") LEADING(@"SEL$870E47C6" ("satp_test"."infraSzsm"@"SEL$5CBA7859_2" ((("satp_test"."sb"@"SEL$5CBA7859_2" (((((((("VIEW1"@"SEL$5CBA7859_2" ("satp_test"."kh"@"SEL$5CBA7859_2" "satp_test"."zjxx"@"SEL$5CBA7859_2")) "satp_test"."gs"@"SEL$5CBA7859_2") "satp_test"."gsSjqr"@"SEL$5CBA7859_2") "VIEW3"@"SEL$5CBA7859_2") "satp_test"."zt"@"SEL$5CBA7859_2") "satp_test"."lzd"@"SEL$5CBA7859_2") "satp_test"."xtzh"@"SEL$5CBA7859_2") "satp_test"."cj"@"SEL$5CBA7859_2")) "satp_test"."jcxx"@"SEL$5CBA7859_2") "satp_test"."szsm"@"SEL$5CBA7859_2"))) USE_HASH(@"SEL$870E47C6" ("satp_test"."zt"@"SEL$5CBA7859_2" "satp_test"."zjxx"@"SEL$5CBA7859_2" "satp_test"."xtzh"@"SEL$5CBA7859_2" "satp_test"."szsm"@"SEL$5CBA7859_2" "satp_test"."sb"@"SEL$5CBA7859_2" "satp_test"."lzd"@"SEL$5CBA7859_2" "satp_test"."kh"@"SEL$5CBA7859_2" "satp_test"."jcxx"@"SEL$5CBA7859_2" "satp_test"."gsSjqr"@"SEL$5CBA7859_2" "satp_test"."gs"@"SEL$5CBA7859_2" "satp_test"."cj"@"SEL$5CBA7859_2" "VIEW3"@"SEL$5CBA7859_2" "VIEW1"@"SEL$5CBA7859_2")) INDEX(@"SEL$870E47C6" "infraSzsm"@"SEL$5CBA7859_2" "idx_ftsp_infra_szsm_1") USE_HASH(@"SEL$870E47C6" "satp_test"."szsm"@"SEL$5CBA7859_2") USE_HASH(@"SEL$870E47C6" "satp_test"."jcxx"@"SEL$5CBA7859_2") USE_HASH(@"SEL$870E47C6" ("satp_test"."zt"@"SEL$5CBA7859_2" "satp_test"."zjxx"@"SEL$5CBA7859_2" "satp_test"."xtzh"@"SEL$5CBA7859_2" "satp_test"."lzd"@"SEL$5CBA7859_2" "satp_test"."kh"@"SEL$5CBA7859_2" "satp_test"."gsSjqr"@"SEL$5CBA7859_2" "satp_test"."gs"@"SEL$5CBA7859_2" "satp_test"."cj"@"SEL$5CBA7859_2" "VIEW3"@"SEL$5CBA7859_2" "VIEW1"@"SEL$5CBA7859_2")) INDEX(@"SEL$870E47C6" "sb"@"SEL$5CBA7859_2" "idx_ftsp_sb_sbxx_3") USE_HASH(@"SEL$870E47C6" "satp_test"."cj"@"SEL$5CBA7859_2") USE_MERGE(@"SEL$870E47C6" "satp_test"."xtzh"@"SEL$5CBA7859_2") USE_NL(@"SEL$870E47C6" "satp_test"."lzd"@"SEL$5CBA7859_2") USE_NL(@"SEL$870E47C6" "satp_test"."zt"@"SEL$5CBA7859_2") USE_NL(@"SEL$870E47C6" "VIEW3"@"SEL$5CBA7859_2") USE_NL(@"SEL$870E47C6" "satp_test"."gsSjqr"@"SEL$5CBA7859_2") USE_NL(@"SEL$870E47C6" "satp_test"."gs"@"SEL$5CBA7859_2") USE_MERGE(@"SEL$870E47C6" ("satp_test"."zjxx"@"SEL$5CBA7859_2" "satp_test"."kh"@"SEL$5CBA7859_2")) LEADING(@"SEL$C79BEC53_3" ("satp_test"."pg_"@"SEL$C79BEC53_3" ("satp_test"."yh_"@"SEL$C79BEC53_3" "satp_test"."bm_"@"SEL$C79BEC53_3"))) USE_NL(@"SEL$C79BEC53_3" ("satp_test"."yh_"@"SEL$C79BEC53_3" "satp_test"."bm_"@"SEL$C79BEC53_3")) USE_NL_MATERIALIZATION(@"SEL$C79BEC53_3" ("satp_test"."yh_"@"SEL$C79BEC53_3" "satp_test"."bm_"@"SEL$C79BEC53_3")) INDEX(@"SEL$C79BEC53_3" "pg_"@"SEL$C79BEC53_3" "idx_ftsp_kh_pg_3") USE_HASH(@"SEL$C79BEC53_3" "satp_test"."bm_"@"SEL$C79BEC53_3") INDEX(@"SEL$C79BEC53_3" "yh_"@"SEL$C79BEC53_3" "idx_ftsp_zj_bmyh_2") INDEX(@"SEL$C79BEC53_3" "bm_"@"SEL$C79BEC53_3" "idx_ftsp_zj_bmxx_1") USE_NL(@"SEL$870E47C6" "satp_test"."zjxx"@"SEL$5CBA7859_2") USE_NL_MATERIALIZATION(@"SEL$870E47C6" "satp_test"."zjxx"@"SEL$5CBA7859_2") INDEX(@"SEL$870E47C6" "kh"@"SEL$5CBA7859_2" "idx_ftsp_kh_khxx_13") FULL(@"SEL$870E47C6" "zjxx"@"SEL$5CBA7859_2") INDEX(@"SEL$870E47C6" "gs"@"SEL$5CBA7859_2" "uk_ftsp_sb_khxx_gs_1") USE_DAS(@"SEL$870E47C6" "gs"@"SEL$5CBA7859_2") INDEX(@"SEL$870E47C6" "gsSjqr"@"SEL$5CBA7859_2" "uk_ftsp_sb_sbxx_status_1") USE_DAS(@"SEL$870E47C6" "gsSjqr"@"SEL$5CBA7859_2") INDEX(@"SEL$DE41DCE6_3" "ht"@"SEL$DE41DCE6_3" "idx_ftsp_ht_htxx_14") USE_DAS(@"SEL$DE41DCE6_3" "ht"@"SEL$DE41DCE6_3") INDEX(@"SEL$870E47C6" "zt"@"SEL$5CBA7859_2" "idx_ftsp_zt_ztxx_1") USE_DAS(@"SEL$870E47C6" "zt"@"SEL$5CBA7859_2") INDEX(@"SEL$870E47C6" "lzd"@"SEL$5CBA7859_2" "uk_ftsp_dj_lzd_1") USE_DAS(@"SEL$870E47C6" "lzd"@"SEL$5CBA7859_2") INDEX(@"SEL$870E47C6" "xtzh"@"SEL$5CBA7859_2" "idx_ftsp_kh_dsf_xtzh_1") FULL(@"SEL$870E47C6" "cj"@"SEL$5CBA7859_2") FULL(@"SEL$870E47C6" "jcxx"@"SEL$5CBA7859_2") FULL(@"SEL$870E47C6" "szsm"@"SEL$5CBA7859_2") REPLACE_CONST(@"SEL$3") UNNEST(@"SEL$9404CA0D") SIMPLIFY_SUBQUERY(@"SEL$7610D21F") SEMI_TO_INNER(@"SEL$67070354" "VIEW1") ELIMINATE_JOIN(@"SEL$656D0309" "satp_test"."cstg"@"SEL$1" "satp_test"."tg"@"SEL$1") PRED_DEDUCE(@"SEL$B2120FD3") USE_CONCAT(@"SEL$B7F83611" 'cast(zjxx.approval_account_, DECIMAL(4, 0)) = cast(?, DECIMAL(1, -1)) OR (T_OP_EXISTS, SQ(SEL$2))') UNNEST(@"SEL$DE41DCE6_3") OPTIMIZER_FEATURES_ENABLE('4.2.2.0') END_OUTLINE_DATA */ Optimization Info: ------------------------------------- infraSzsm: table_rows:1255 physical_range_rows:1255 logical_range_rows:1255 index_back_rows:0 output_rows:1255 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_infra_szsm_1, ftsp_infra_szsm] pruned_index_name:[ftsp_infra_szsm] stats version:1712977364125852 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] pg_: table_rows:3368701 physical_range_rows:384 logical_range_rows:384 index_back_rows:0 output_rows:384 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_pg_1, idx_ftsp_kh_pg_2, idx_ftsp_kh_pg_3, ftsp_kh_pg] pruned_index_name:[idx_ftsp_kh_pg_1, idx_ftsp_kh_pg_2, ftsp_kh_pg] stats version:1712976326587440 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] yh_: table_rows:317236 physical_range_rows:1 logical_range_rows:1 index_back_rows:1 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_bmyh_1, idx_ftsp_zj_bmyh_2, ftsp_zj_bmyh] pruned_index_name:[ftsp_zj_bmyh] stats version:1712941490725069 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] bm_: table_rows:31284 physical_range_rows:52 logical_range_rows:52 index_back_rows:0 output_rows:52 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_bmxx_1, idx_ftsp_zj_bmxx_2, idx_ftsp_zj_bmxx_3, idx_ftsp_zj_bmxx_4, ftsp_zj_bmxx] pruned_index_name:[idx_ftsp_zj_bmxx_2, idx_ftsp_zj_bmxx_3, idx_ftsp_zj_bmxx_4] unstable_index_name:[ftsp_zj_bmxx] stats version:1712941419533266 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] kh: table_rows:1162365 physical_range_rows:1131 logical_range_rows:1131 index_back_rows:0 output_rows:1131 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_khxx_1, idx_ftsp_kh_khxx_11, idx_ftsp_kh_khxx_12, idx_ftsp_kh_khxx_13, idx_ftsp_kh_khxx_2, idx_ftsp_kh_khxx_3, idx_ftsp_kh_khxx_4, idx_ftsp_kh_khxx_5, idx_ftsp_kh_khxx_6, idx_ftsp_kh_khxx_7, idx_ftsp_kh_khxx_8, idx_ftsp_kh_khxx_9, ftsp_kh_khxx] pruned_index_name:[idx_ftsp_kh_khxx_1, idx_ftsp_kh_khxx_11, idx_ftsp_kh_khxx_12, idx_ftsp_kh_khxx_2, idx_ftsp_kh_khxx_3, idx_ftsp_kh_khxx_4, idx_ftsp_kh_khxx_5, idx_ftsp_kh_khxx_6, idx_ftsp_kh_khxx_7, idx_ftsp_kh_khxx_8, idx_ftsp_kh_khxx_9, ftsp_kh_khxx] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] zjxx: table_rows:2382 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:0 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_zjxx_1, idx_ftsp_zj_zjxx_2, idx_ftsp_zj_zjxx_3, idx_ftsp_zj_zjxx_4, idx_ftsp_zj_zjxx_5, idx_ftsp_zj_zjxx_6, ftsp_zj_zjxx] pruned_index_name:[idx_ftsp_zj_zjxx_1, idx_ftsp_zj_zjxx_2, idx_ftsp_zj_zjxx_3, idx_ftsp_zj_zjxx_4, idx_ftsp_zj_zjxx_5, idx_ftsp_zj_zjxx_6] stats version:1712975110081737 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] gsSjqr: table_rows:726557 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_sb_sbxx_status_1, idx_ftsp_sb_sbxx_status_2, ftsp_sb_sbxx_status] pruned_index_name:[ftsp_sb_sbxx_status] stats version:1712975331942457 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] gs: table_rows:23322829 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_sb_khxx_gs_1, ftsp_sb_khxx_gs] pruned_index_name:[ftsp_sb_khxx_gs] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING BASIC] cj: table_rows:1132664 physical_range_rows:1 logical_range_rows:1 index_back_rows:1 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[ftsp_kh_cjxx_index, ftsp_kh_cjxx] pruned_index_name:[ftsp_kh_cjxx] stats version:1712766351158861 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] zt: table_rows:1286540 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[idx_ftsp_zt_ztxx_1, idx_ftsp_zt_ztxx_2, ftsp_zt_ztxx] pruned_index_name:[ftsp_zt_ztxx] stats version:1712931615287367 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] xtzh: table_rows:2460523 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[idx_ftsp_kh_dsf_xtzh_1, idx_ftsp_kh_dsf_xtzh_3, ftsp_kh_dsf_xtzh] pruned_index_name:[idx_ftsp_kh_dsf_xtzh_3, ftsp_kh_dsf_xtzh] stats version:1712942567495479 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] sb: table_rows:34070124 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_sb_sbxx, idx_ftsp_sb_sbxx_2, idx_ftsp_sb_sbxx_3, ftsp_sb_sbxx] pruned_index_name:[idx_ftsp_sb_sbxx_2, idx_ftsp_sb_sbxx_3, ftsp_sb_sbxx] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING BASIC] lzd: table_rows:18606638 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_dj_lzd_1, ftsp_dj_lzd] pruned_index_name:[ftsp_dj_lzd] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING BASIC] jcxx: table_rows:1924625 physical_range_rows:1924625 logical_range_rows:1924625 index_back_rows:0 output_rows:1924625 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_jcxx_1, idx_ftsp_kh_jcxx_2, idx_ftsp_kh_jcxx_3, ftsp_kh_jcxx] pruned_index_name:[idx_ftsp_kh_jcxx_2, idx_ftsp_kh_jcxx_3] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] szsm: table_rows:10397678 physical_range_rows:10397678 logical_range_rows:10397678 index_back_rows:0 output_rows:1216196 table_dop:1 dop_method:Table DOP avaiable_index_name:[uk_ftsp_kh_szhd_szsm, idx_ftsp_kh_szhd_szsm_1, ftsp_kh_szhd_szsm] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] infraSzsm: table_rows:1255 physical_range_rows:1255 logical_range_rows:1255 index_back_rows:0 output_rows:1255 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_infra_szsm_1, ftsp_infra_szsm] pruned_index_name:[ftsp_infra_szsm] stats version:1712977364125852 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] sb: table_rows:34070124 physical_range_rows:3100 logical_range_rows:3100 index_back_rows:3100 output_rows:3100 table_dop:1 dop_method:Table DOP avaiable_index_name:[uk_ftsp_sb_sbxx, idx_ftsp_sb_sbxx_2, idx_ftsp_sb_sbxx_3, ftsp_sb_sbxx] pruned_index_name:[idx_ftsp_sb_sbxx_2, ftsp_sb_sbxx] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] pg_: table_rows:3368701 physical_range_rows:384 logical_range_rows:384 index_back_rows:0 output_rows:384 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_pg_1, idx_ftsp_kh_pg_2, idx_ftsp_kh_pg_3, ftsp_kh_pg] pruned_index_name:[idx_ftsp_kh_pg_1, idx_ftsp_kh_pg_2, ftsp_kh_pg] stats version:1712976326587440 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] yh_: table_rows:317236 physical_range_rows:1 logical_range_rows:1 index_back_rows:1 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_bmyh_1, idx_ftsp_zj_bmyh_2, ftsp_zj_bmyh] pruned_index_name:[ftsp_zj_bmyh] stats version:1712941490725069 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] bm_: table_rows:31284 physical_range_rows:52 logical_range_rows:52 index_back_rows:0 output_rows:52 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_bmxx_1, idx_ftsp_zj_bmxx_2, idx_ftsp_zj_bmxx_3, idx_ftsp_zj_bmxx_4, ftsp_zj_bmxx] pruned_index_name:[idx_ftsp_zj_bmxx_2, idx_ftsp_zj_bmxx_3, idx_ftsp_zj_bmxx_4] unstable_index_name:[ftsp_zj_bmxx] stats version:1712941419533266 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] kh: table_rows:1162365 physical_range_rows:1131 logical_range_rows:1131 index_back_rows:0 output_rows:1131 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_khxx_1, idx_ftsp_kh_khxx_11, idx_ftsp_kh_khxx_12, idx_ftsp_kh_khxx_13, idx_ftsp_kh_khxx_2, idx_ftsp_kh_khxx_3, idx_ftsp_kh_khxx_4, idx_ftsp_kh_khxx_5, idx_ftsp_kh_khxx_6, idx_ftsp_kh_khxx_7, idx_ftsp_kh_khxx_8, idx_ftsp_kh_khxx_9, ftsp_kh_khxx] pruned_index_name:[idx_ftsp_kh_khxx_1, idx_ftsp_kh_khxx_11, idx_ftsp_kh_khxx_12, idx_ftsp_kh_khxx_2, idx_ftsp_kh_khxx_3, idx_ftsp_kh_khxx_4, idx_ftsp_kh_khxx_5, idx_ftsp_kh_khxx_6, idx_ftsp_kh_khxx_7, idx_ftsp_kh_khxx_8, idx_ftsp_kh_khxx_9, ftsp_kh_khxx] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] zjxx: table_rows:2382 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:0 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_zj_zjxx_1, idx_ftsp_zj_zjxx_2, idx_ftsp_zj_zjxx_3, idx_ftsp_zj_zjxx_4, idx_ftsp_zj_zjxx_5, idx_ftsp_zj_zjxx_6, ftsp_zj_zjxx] pruned_index_name:[idx_ftsp_zj_zjxx_1, idx_ftsp_zj_zjxx_2, idx_ftsp_zj_zjxx_3, idx_ftsp_zj_zjxx_4, idx_ftsp_zj_zjxx_5, idx_ftsp_zj_zjxx_6] stats version:1712975110081737 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] gs: table_rows:23322829 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_sb_khxx_gs_1, ftsp_sb_khxx_gs] pruned_index_name:[ftsp_sb_khxx_gs] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING BASIC] gsSjqr: table_rows:726557 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_sb_sbxx_status_1, idx_ftsp_sb_sbxx_status_2, ftsp_sb_sbxx_status] pruned_index_name:[ftsp_sb_sbxx_status] stats version:1712975331942457 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] ht: table_rows:3263215 physical_range_rows:9 logical_range_rows:9 index_back_rows:0 output_rows:0 table_dop:1 dop_method:DAS DOP avaiable_index_name:[idx_ftsp_ht_htxx_1, idx_ftsp_ht_htxx_10, idx_ftsp_ht_htxx_11, idx_ftsp_ht_htxx_12, idx_ftsp_ht_htxx_13, idx_ftsp_ht_htxx_14, idx_ftsp_ht_htxx_15, idx_ftsp_ht_htxx_16, idx_ftsp_ht_htxx_17, idx_ftsp_ht_htxx_18, idx_ftsp_ht_htxx_19, idx_ftsp_ht_htxx_2, idx_ftsp_ht_htxx_20, idx_ftsp_ht_htxx_21, idx_ftsp_ht_htxx_22, idx_ftsp_ht_htxx_23, idx_ftsp_ht_htxx_3, idx_ftsp_ht_htxx_4, idx_ftsp_ht_htxx_5, idx_ftsp_ht_htxx_6, idx_ftsp_ht_htxx_7, idx_ftsp_ht_htxx_8, idx_ftsp_ht_htxx_9, ftsp_ht_htxx] pruned_index_name:[idx_ftsp_ht_htxx_10, idx_ftsp_ht_htxx_11, idx_ftsp_ht_htxx_12, idx_ftsp_ht_htxx_15, idx_ftsp_ht_htxx_17, idx_ftsp_ht_htxx_18, idx_ftsp_ht_htxx_19, idx_ftsp_ht_htxx_2, idx_ftsp_ht_htxx_20, idx_ftsp_ht_htxx_22, idx_ftsp_ht_htxx_23, idx_ftsp_ht_htxx_3, idx_ftsp_ht_htxx_4, idx_ftsp_ht_htxx_5, idx_ftsp_ht_htxx_6, idx_ftsp_ht_htxx_8, idx_ftsp_ht_htxx_9, ftsp_ht_htxx] stats version:0 dynamic sampling level:0 estimation method:[DEFAULT, STORAGE] zt: table_rows:1286540 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[idx_ftsp_zt_ztxx_1, idx_ftsp_zt_ztxx_2, ftsp_zt_ztxx] pruned_index_name:[ftsp_zt_ztxx] stats version:1712931615287367 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS] lzd: table_rows:18606638 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:DAS DOP avaiable_index_name:[uk_ftsp_dj_lzd_1, ftsp_dj_lzd] pruned_index_name:[ftsp_dj_lzd] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING BASIC] xtzh: table_rows:2460523 physical_range_rows:2460541 logical_range_rows:2460541 index_back_rows:0 output_rows:913450 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_dsf_xtzh_1, idx_ftsp_kh_dsf_xtzh_3, ftsp_kh_dsf_xtzh] pruned_index_name:[ftsp_kh_dsf_xtzh] stats version:1712942567495479 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] cj: table_rows:1132664 physical_range_rows:1132673 logical_range_rows:1132673 index_back_rows:0 output_rows:1132673 table_dop:1 dop_method:Table DOP avaiable_index_name:[ftsp_kh_cjxx_index, ftsp_kh_cjxx] stats version:1712766351158861 dynamic sampling level:0 estimation method:[OPTIMIZER STATISTICS, STORAGE] jcxx: table_rows:1924625 physical_range_rows:1924625 logical_range_rows:1924625 index_back_rows:0 output_rows:1924625 table_dop:1 dop_method:Table DOP avaiable_index_name:[idx_ftsp_kh_jcxx_1, idx_ftsp_kh_jcxx_2, idx_ftsp_kh_jcxx_3, ftsp_kh_jcxx] pruned_index_name:[idx_ftsp_kh_jcxx_2, idx_ftsp_kh_jcxx_3] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] szsm: table_rows:10397678 physical_range_rows:10397678 logical_range_rows:10397678 index_back_rows:0 output_rows:1216196 table_dop:1 dop_method:Table DOP avaiable_index_name:[uk_ftsp_kh_szhd_szsm, idx_ftsp_kh_szhd_szsm_1, ftsp_kh_szhd_szsm] stats version:0 dynamic sampling level:1 estimation method:[DYNAMIC SAMPLING FULL] Plan Type: LOCAL Note: Degree of Parallelisim is 1 because of table property