在工單系統上看到有一條sql問題還沒解決，工單描述看到壓測場景被cpu資源被這條sql打爆，目前影響到專案進度，比較緊急。
直接聯絡這位同學看看是否需要幫忙。
慢SQL：
SELECT task.*, sc01.aab300 bjsjjg, (SELECT sc05.bsc012 FROM sc05 WHERE task.coperator = sc05.bsc010) coperatorName, (SELECT sc01.aab300 FROM sc01 WHERE task.ywgxd = sc01.bsc001) ywjbbm, (SELECT sc05.bsc012 FROM sc05 WHERE task.assignee = sc05.bsc010) qlrmc, (SELECT v_bjxx_oversee.OVERSEE_TYPE FROM v_bjxx_oversee WHERE task.ID = v_bjxx_oversee.Bjxx_Id) overdueStatus, (SELECT TRUNC(v_bjxx_oversee.CNSJ - SYSDATE, 2) FROM v_bjxx_oversee WHERE task.ID = v_bjxx_oversee.Bjxx_Id) surplusDays FROM ( SELECT task.*, CASE WHEN task.assignee = '1440' THEN '1' ELSE '0' END assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, NVL(form.batch, 0) batch FROM v_bjxx_task task INNER JOIN act_ru_task bl ON bl.proc_inst_id_ = task.BLLC_PROC_INST_ID_ LEFT JOIN form ON ( bl.task_def_key_ = form.nodeid AND bl.proc_def_id_ = form.procdefid AND form.planid = task.PLAN_ID AND form.zzd = '1') WHERE task.assignee = '1440' OR ( task.assignee IS NULL AND EXISTS ( SELECT 1 FROM task_assignee tase WHERE tase.bsc010 = '1440' AND task.id = tase.bjxxid AND task.gwtaskid = tase.gwtaskid ) ) ) task, sc01, gwpz WHERE gwpz.planid = task.PLAN_ID AND gwpz.gwjdid = task.gwjdid AND gwpz.bllcjdid = task.task_def_key_ AND gwpz.bllcyqid = task.proc_def_id_ AND gwpz.gwlcid = task.gwlcid AND task.batch = 0 AND task.ywfsxd = sc01.bsc001(+);
這條sql返回4條資料，但是執行時間很長，好像幾百秒才執行完，執行次數也多，都壓測不下去了。
排查了下其實主要是 task 這段內連檢視影響導致，這段邏輯跑 478.27秒，返回4行資料，主要資料來源就是這段邏輯。
/* 資料量： v_bjxx_task as task 檢視：243.16 w act_ru_task as bl 表： 1599.05w task_assignee as tase 表： 4584.40w form as form 表： 6.12w */ SELECT task.*, '1' assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, (SELECT nvl(form.batch, 0) batch FROM form WHERE bl.task_def_key_ = form.nodeid AND bl.proc_def_id_ = form.procdefid AND form.planid = task.PLAN_ID AND form.zzd='1' ) batch FROM v_bjxx_task task, act_ru_task bl WHERE bl.proc_inst_id_ = task.BLLC_PROC_INST_ID_ AND task.assignee = '1440' UNION allSELECT task.*, '0' assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, (SELECT nvl(form.batch, 0) batch FROM form WHERE bl.task_def_key_ = form.nodeid AND bl.proc_def_id_ = form.procdefid AND form.planid = task.PLAN_ID AND form.zzd='1' ) batch FROM v_bjxx_task task, (SELECT DISTINCT tase.bjxxid, tase.gwtaskid, tase.bsc010, tase.bsc001 FROM task_assignee tase) ta, act_ru_task bl WHERE task.id = ta.bjxxid AND task.gwtaskid = ta.gwtaskid AND task.assignee is null AND bl.proc_inst_id_ = task.BLLC_PROC_INST_ID_ AND ta.bsc010= '1440' ; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ===================================================================================================== | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | ----------------------------------------------------------------------------------------------------- | | |0 |TEMP TABLE TRANSFORMATION | |3090176 |35717409065 | | | |1 |├─TEMP TABLE INSERT |TEMP1 |2995267 |186788043 | | | |2 |│ └─HASH JOIN | |2995267 |177870262 | | | |3 |│ ├─PX COORDINATOR | |13099764|60671090 | | | |4 |│ │ └─EXCHANGE OUT DISTR |:EX10000 |13099764|42555142 | | | |5 |│ │ └─PX PARTITION ITERATOR | |13099764|1808746 | | | |6 |│ │ └─TABLE FULL SCAN |ACT |13099764|1808746 | | | |7 |│ └─HASH JOIN | |2937089 |108316902 | | | |8 |│ ├─TABLE FULL SCAN |SX |128752 |11528 | | | |9 |│ └─PX COORDINATOR | |2937089 |107251909 | | | |10|│ └─EXCHANGE OUT DISTR |:EX20000 |2937089 |75006584 | | | |11|│ └─TABLE FULL SCAN |BT |2937089 |2412876 | | | |12|└─UNION ALL | |3090176 |35530621023 | | | |13| ├─SUBPLAN FILTER | |3090176 |35530600912 | | | |14| │ ├─HASH JOIN | |3090176 |35454536498 | | | |15| │ │ ├─PX COORDINATOR | |15990828|78905666 | | | |16| │ │ │ └─EXCHANGE OUT DISTR |:EX30000 |15990828|55128664 | | | |17| │ │ │ └─PX PARTITION ITERATOR | |15990828|1645439 | | | |18| │ │ │ └─TABLE FULL SCAN |BL |15990828|1645439 | | | |19| │ │ └─SUBPLAN SCAN |V_BJXX_TASK |2995267 |35364626635 | | | |20| │ │ └─SUBPLAN FILTER | |2995267 |35364618707 | | | |21| │ │ ├─TEMP TABLE ACCESS |VIEW1(TEMP1) |2995267 |120812 | | | |22| │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |23| │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |24| │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |25| │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |26| │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |27| │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |28| │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |29| │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |30| │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |31| │ │ └─DISTRIBUTED TABLE RANGE SCAN |BX |1 |11692 | | | |32| │ └─DISTRIBUTED TABLE RANGE SCAN |FORM(IDX_FORM_PLAN) |1 |25 | | | |33| └─SUBPLAN FILTER | |0 |11932 | | | |34| ├─NESTED-LOOP JOIN | |0 |11907 | | | |35| │ ├─NESTED-LOOP JOIN | |0 |11855 | | | |36| │ │ ├─SUBPLAN SCAN |V_BJXX_TASK |0 |11807 | | | |37| │ │ │ └─SUBPLAN FILTER | |0 |11807 | | | |38| │ │ │ ├─TEMP TABLE ACCESS |VIEW2(TEMP1) |0 |0 | | | |39| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |40| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |41| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |42| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |43| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |44| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |45| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |46| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |47| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |48| │ │ │ └─DISTRIBUTED TABLE RANGE SCAN|BX |1 |11692 | | | |49| │ │ └─SUBPLAN SCAN |TA |1 |47 | | | |50| │ │ └─HASH DISTINCT | |1 |47 | | | |51| │ │ └─DISTRIBUTED TABLE RANGE SCAN|TASE(IDX$$_22880002_FQ) |1 |47 | | | |52| │ └─DISTRIBUTED TABLE RANGE SCAN |BL(FQIDX1_TASK_PROC_INST_ID__2)|2 |52 | | | |53| └─DISTRIBUTED TABLE RANGE SCAN |FORM(IDX_FORM_PLAN) |1 |25 | | | ===================================================================================================== | | Outputs & filters: | | ------------------------------------- | | 0 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])], [UNION([5])], [UNION([6])], [UNION([7])], [UNION([8])], [UNION([9])], [UNION([10])], | | [UNION([11])], [UNION([12])], [UNION([13])], [UNION([14])], [UNION([15])], [UNION([16])], [UNION([17])], [UNION([18])], [UNION([19])], [UNION([20])], [UNION([21])], | | [UNION([22])], [UNION([23])], [UNION([24])], [UNION([25])], [UNION([26])], [UNION([27])], [UNION([28])], [UNION([29])], [UNION([30])], [UNION([31])], [UNION([32])], | | [UNION([33])], [UNION([34])], [UNION([35])], [UNION([36])], [UNION([37])], [UNION([38])], [UNION([39])], [UNION([40])], [UNION([41])], [UNION([42])], [UNION([43])], | | [UNION([44])], [UNION([45])], [UNION([46])], [UNION([47])], [UNION([48])], [UNION([49])], [UNION([50])], [UNION([51])], [UNION([52])], [UNION([53])], [UNION([54])], | | [UNION([55])], [UNION([56])], [UNION([57])], [UNION([58])], [UNION([59])], [UNION([60])], [UNION([61])], [UNION([62])], [UNION([63])], [UNION([64])], [UNION([65])], | | [UNION([66])], [UNION([67])], [UNION([68])], [UNION([69])], [UNION([70])], [UNION([71])], [UNION([72])], [UNION([73])], [UNION([74])], [UNION([75])], [UNION([76])], | | [UNION([77])], [UNION([78])], [UNION([79])], [UNION([80])], [UNION([81])], [UNION([82])], [UNION([83])], [UNION([84])], [UNION([85])], [UNION([86])], [UNION([87])], | | [UNION([88])], [UNION([89])]), filter(nil), rowset=256 | | 1 - output(nil), filter(nil), rowset=256 | | 2 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME], [SX.SXMC], [SX.SXMC_SXBM], | | [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH], [ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | equal_conds([BT.GW_PROC_INST_ID_ = ACT.PROC_INST_ID_]), other_conds(nil) | | 3 - output([ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_], [ACT.PROC_INST_ID_]), filter(nil), rowset=256 | | 4 - output([ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_], [ACT.PROC_INST_ID_]), filter(nil), rowset=256 | | dop=1 | | 5 - output([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | force partition granule | | 6 - output([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter([ACT.ASSIGNEE_ = cast('1440', VARCHAR2(1048576 | | )) OR ACT.ASSIGNEE_ IS NULL]), rowset=256 | | access([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), partitions(p[0-15]) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([ACT.ID_]), range(MIN ; MAX)always true | | 7 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME], [SX.SXMC], [SX.SXMC_SXBM], | | [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), filter(nil), rowset=256 | | equal_conds([BT.SX_ID = SX.ID]), other_conds(nil) | | 8 - output([SX.ID], [SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), filter(nil), rowset=256 | | access([SX.ID], [SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([SX.ID]), range(MIN ; MAX)always true | | 9 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), filter(nil), rowset=256 | | 10 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), filter(nil), rowset=256 | | is_single, dop=1 | | 11 - output([BT.ID], [BT.SX_ID], [BT.GW_PROC_INST_ID_], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], | | [BT.SQZTZJHM], [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], | | [BT.YWFSXD], [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], | | [BT.PLAN_ID], [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], [BT.GWZT], | | [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), filter(nil), rowset=256 | | access([BT.ID], [BT.SX_ID], [BT.GW_PROC_INST_ID_], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], | | [BT.SQZTZJHM], [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], | | [BT.YWFSXD], [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], | | [BT.PLAN_ID], [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], [BT.GWZT], | | [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([BT.ID]), range(MIN ; MAX)always true | | 12 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])], [UNION([5])], [UNION([6])], [UNION([7])], [UNION([8])], [UNION([9])], [UNION([10])], | | [UNION([11])], [UNION([12])], [UNION([13])], [UNION([14])], [UNION([15])], [UNION([16])], [UNION([17])], [UNION([18])], [UNION([19])], [UNION([20])], [UNION([21])], | | [UNION([22])], [UNION([23])], [UNION([24])], [UNION([25])], [UNION([26])], [UNION([27])], [UNION([28])], [UNION([29])], [UNION([30])], [UNION([31])], [UNION([32])], | | [UNION([33])], [UNION([34])], [UNION([35])], [UNION([36])], [UNION([37])], [UNION([38])], [UNION([39])], [UNION([40])], [UNION([41])], [UNION([42])], [UNION([43])], | | [UNION([44])], [UNION([45])], [UNION([46])], [UNION([47])], [UNION([48])], [UNION([49])], [UNION([50])], [UNION([51])], [UNION([52])], [UNION([53])], [UNION([54])], | | [UNION([55])], [UNION([56])], [UNION([57])], [UNION([58])], [UNION([59])], [UNION([60])], [UNION([61])], [UNION([62])], [UNION([63])], [UNION([64])], [UNION([65])], | | [UNION([66])], [UNION([67])], [UNION([68])], [UNION([69])], [UNION([70])], [UNION([71])], [UNION([72])], [UNION([73])], [UNION([74])], [UNION([75])], [UNION([76])], | | [UNION([77])], [UNION([78])], [UNION([79])], [UNION([80])], [UNION([81])], [UNION([82])], [UNION([83])], [UNION([84])], [UNION([85])], [UNION([86])], [UNION([87])], | | [UNION([88])], [UNION([89])]), filter(nil), rowset=256 | | 13 - output([TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], | | [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], | | [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], | | [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID], ['1'], | | [BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [subquery(1)]), filter(nil), rowset=256 | | exec_params_([BL.TASK_DEF_KEY_(:0)], [BL.PROC_DEF_ID_(:1)], [TASK.PLAN_ID(:2)]), onetime_exprs_(nil), init_plan_idxs_(nil), use_batch=false | | 14 - output([BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], | | [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], | | [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], | | [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], | | [TASK.GWLCID], [BL.ID_], [BL.NAME_]), filter(nil), rowset=256 | | equal_conds([BL.PROC_INST_ID_ = TASK.BLLC_PROC_INST_ID_]), other_conds(nil) | | 15 - output([BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.ID_], [BL.NAME_], [BL.PROC_INST_ID_]), filter(nil), rowset=256 | | 16 - output([BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.ID_], [BL.NAME_], [BL.PROC_INST_ID_]), filter(nil), rowset=256 | | dop=1 | | 17 - output([BL.ID_], [BL.PROC_INST_ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), filter(nil), rowset=256 | | force partition granule | | 18 - output([BL.ID_], [BL.PROC_INST_ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), filter(nil), rowset=256 | | access([BL.ID_], [BL.PROC_INST_ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), partitions(p[0-15]) | | is_index_back=false, is_global_index=false, | | range_key([BL.ID_]), range(MIN ; MAX)always true | | 19 - output([TASK.BLLC_PROC_INST_ID_], [TASK.ASSIGNEE], [TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], | | [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], | | [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], | | [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], | | [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], | | [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], | | [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], | | [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID]), filter(nil), rowset=256 | | access([TASK.BLLC_PROC_INST_ID_], [TASK.ASSIGNEE], [TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], | | [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], | | [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], | | [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], | | [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], | | [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], | | [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], | | [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID]) | | 20 - output([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.SX_ID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], | | [VIEW1.BT.SXJCJG], [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [subquery(1)], [subquery(2)], [subquery(3)], | | [subquery(4)], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], | | [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | exec_params_([VIEW1.BT.COPERATOR(:3)], [VIEW1.BT.COPERATOR(:4)], [VIEW1.BT.COPERATOR(:5)], [VIEW1.BT.ID(:6)]), onetime_exprs_(nil), init_plan_idxs_(nil), | | use_batch=false | | 21 - output([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], [VIEW1.BT.SXJCJG], | | [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], | | [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]), filter([VIEW1.ACT.ASSIGNEE_ = cast('1440', VARCHAR2(1048576 ))]), rowset=256 | | access([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], [VIEW1.BT.SXJCJG], | | [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], | | [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]) | | 22 - output([T.BSC011]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:18)]), use_batch=false | | 23 - output([T.BSC011], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC011], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :3]) | | 24 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:18 = T.BSC001]) | | 25 - output([T.BSC012]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:20)]), use_batch=false | | 26 - output([T.BSC012], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC012], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :4]) | | 27 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:20 = T.BSC001]) | | 28 - output([T.AAB300]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:22)]), use_batch=false | | 29 - output([T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :5]) | | 30 - output([T.AAB300]), filter(nil), rowset=256 | | access([T.AAB300]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:22 = T.BSC001]) | | 31 - output([BX.BJLY]), filter(nil), rowset=256 | | access([BX.BJLY]), partitions(p0sp[0-7], p1sp[0-7], p2sp[0-7], p3sp[0-7], p4sp[0-7], p5sp[0-7], p6sp[0-7], p7sp[0-7], p8sp[0-7], p9sp[0-7], p10sp[0-7], | | p11sp[0-7], p12sp[0-7], p13sp[0-7], p14sp[0-7], p15sp[0-7], p16sp[0-7], p17sp[0-7], p18sp[0-7], p19sp[0-7], p20sp[0-7], p21sp[0-7], p22sp[0-7], p23sp[0-7], | | p24sp[0-7], p25sp[0-7], p26sp[0-7], p27sp[0-7], p28sp[0-7], p29sp[0-7], p30sp[0-7], p31sp[0-7], p32sp[0-7], p33sp[0-7], p34sp[0-7], p35sp[0-7], p36sp[0-7], | | p37sp[0-7], p38sp[0-7], p39sp[0-7], p40sp[0-7], p41sp[0-7], p42sp[0-7], p43sp[0-7], p44sp[0-7], p45sp[0-7], p46sp[0-7], p47sp[0-7], p48sp[0-7], p49sp[0-7], | | p50sp[0-7], p51sp[0-7], p52sp[0-7], p53sp[0-7], p54sp[0-7], p55sp[0-7], p56sp[0-7], p57sp[0-7], p58sp[0-7], p59sp[0-7], p60sp[0-7], p61sp[0-7], p62sp[0-7], | | p63sp[0-7], p64sp[0-7], p65sp[0-7], p66sp[0-7], p67sp[0-7], p68sp[0-7], p69sp[0-7], p70sp[0-7], p71sp[0-7], p72sp[0-7]) | | is_index_back=false, is_global_index=false, | | range_key([BX.ID], [BX.CTIME]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([BX.ID = :6]) | | 32 - output([NVL(FORM.BATCH, cast(0, VARCHAR2(1 BYTE)))]), filter([FORM.ZZD = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([FORM.ID], [FORM.BATCH], [FORM.ZZD]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([FORM.NODEID], [FORM.PLANID], [FORM.PROCDEFID], [FORM.BATCH], [FORM.ID]), range(MIN,MIN,MIN,MIN,MIN ; MAX,MAX,MAX,MAX,MAX)always true, | | range_cond([:0 = FORM.NODEID], [:1 = FORM.PROCDEFID], [FORM.PLANID = :2]) | | 33 - output([TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], | | [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], | | [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], | | [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID], ['0'], | | [BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [subquery(1)]), filter(nil), rowset=256 | | exec_params_([BL.TASK_DEF_KEY_(:7)], [BL.PROC_DEF_ID_(:8)], [TASK.PLAN_ID(:9)]), onetime_exprs_(nil), init_plan_idxs_(nil), use_batch=false | | 34 - output([BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], | | [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], | | [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], | | [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], | | [TASK.GWLCID], [BL.ID_], [BL.NAME_]), filter(nil), rowset=256 | | conds(nil), nl_params_([TASK.BLLC_PROC_INST_ID_(:36)]), use_batch=false | | 35 - output([TASK.PLAN_ID], [TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], | | [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], | | [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], | | [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID]), filter(nil), rowset=256 | | conds(nil), nl_params_([TASK.ID(:32)], [TASK.GWTASKID(:33)]), use_batch=false | | 36 - output([TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.BLLC_PROC_INST_ID_], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], | | [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], | | [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], | | [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]), filter(nil), rowset=256 | | access([TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.BLLC_PROC_INST_ID_], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], | | [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], | | [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], | | [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]) | | 37 - output([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.SX_ID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], | | [VIEW2.BT.SXJCJG], [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [subquery(1)], [subquery(2)], [subquery(3)], | | [subquery(4)], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], | | [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | exec_params_([VIEW2.BT.COPERATOR(:10)], [VIEW2.BT.COPERATOR(:11)], [VIEW2.BT.COPERATOR(:12)], [VIEW2.BT.ID(:13)]), onetime_exprs_(nil), init_plan_idxs_(nil), | | use_batch=false | | 38 - output([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], [VIEW2.BT.SXJCJG], | | [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], | | [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]), filter([VIEW2.ACT.ASSIGNEE_ IS NULL]), rowset=256 | | access([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], [VIEW2.BT.SXJCJG], | | [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], | | [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]) | | 39 - output([T.BSC011]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:26)]), use_batch=false | | 40 - output([T.BSC011], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC011], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :10]) | | 41 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:26 = T.BSC001]) | | 42 - output([T.BSC012]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:28)]), use_batch=false | | 43 - output([T.BSC012], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC012], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :11]) | | 44 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:28 = T.BSC001]) | | 45 - output([T.AAB300]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:30)]), use_batch=false | | 46 - output([T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :12]) | | 47 - output([T.AAB300]), filter(nil), rowset=256 | | access([T.AAB300]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:30 = T.BSC001]) | | 48 - output([BX.BJLY]), filter(nil), rowset=256 | | access([BX.BJLY]), partitions(p0sp[0-7], p1sp[0-7], p2sp[0-7], p3sp[0-7], p4sp[0-7], p5sp[0-7], p6sp[0-7], p7sp[0-7], p8sp[0-7], p9sp[0-7], p10sp[0-7], | | p11sp[0-7], p12sp[0-7], p13sp[0-7], p14sp[0-7], p15sp[0-7], p16sp[0-7], p17sp[0-7], p18sp[0-7], p19sp[0-7], p20sp[0-7], p21sp[0-7], p22sp[0-7], p23sp[0-7], | | p24sp[0-7], p25sp[0-7], p26sp[0-7], p27sp[0-7], p28sp[0-7], p29sp[0-7], p30sp[0-7], p31sp[0-7], p32sp[0-7], p33sp[0-7], p34sp[0-7], p35sp[0-7], p36sp[0-7], | | p37sp[0-7], p38sp[0-7], p39sp[0-7], p40sp[0-7], p41sp[0-7], p42sp[0-7], p43sp[0-7], p44sp[0-7], p45sp[0-7], p46sp[0-7], p47sp[0-7], p48sp[0-7], p49sp[0-7], | | p50sp[0-7], p51sp[0-7], p52sp[0-7], p53sp[0-7], p54sp[0-7], p55sp[0-7], p56sp[0-7], p57sp[0-7], p58sp[0-7], p59sp[0-7], p60sp[0-7], p61sp[0-7], p62sp[0-7], | | p63sp[0-7], p64sp[0-7], p65sp[0-7], p66sp[0-7], p67sp[0-7], p68sp[0-7], p69sp[0-7], p70sp[0-7], p71sp[0-7], p72sp[0-7]) | | is_index_back=false, is_global_index=false, | | range_key([BX.ID], [BX.CTIME]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([BX.ID = :13]) | | 49 - output(nil), filter(nil), rowset=256 | | access(nil) | | 50 - output([TASE.BJXXID], [TASE.GWTASKID], [TASE.BSC010], [TASE.BSC001]), filter(nil), rowset=256 | | distinct([TASE.BSC001]) | | 51 - output([TASE.GWTASKID], [TASE.BSC010], [TASE.BJXXID], [TASE.BSC001]), filter([TASE.BSC010 = cast('1440', VARCHAR2(1048576 ))]), rowset=256 | | access([TASE.__pk_increment], [TASE.GWTASKID], [TASE.BSC010], [TASE.BJXXID], [TASE.BSC001]), partitions(p0) | | is_index_back=true, is_global_index=true, filter_before_indexback[false], | | range_key([TASE.BJXXID], [TASE.GWTASKID], [TASE.__pk_increment]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true, | | range_cond([:32 = TASE.BJXXID], [:33 = TASE.GWTASKID]) | | 52 - output([BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), filter(nil), rowset=256 | | access([BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), partitions(p0) | | is_index_back=true, is_global_index=true, | | range_key([BL.PROC_INST_ID_], [BL.ID_]), range(MIN ; MAX), | | range_cond([BL.PROC_INST_ID_ = :36]) | | 53 - output([NVL(FORM.BATCH, cast(0, VARCHAR2(1 BYTE)))]), filter([FORM.ZZD = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([FORM.ID], [FORM.BATCH], [FORM.ZZD]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([FORM.NODEID], [FORM.PLANID], [FORM.PROCDEFID], [FORM.BATCH], [FORM.ID]), range(MIN,MIN,MIN,MIN,MIN ; MAX,MAX,MAX,MAX,MAX)always true, | | range_cond([:7 = FORM.NODEID], [:8 = FORM.PROCDEFID], [FORM.PLANID = :9]) | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 396 rows in set (0.217 sec)
遇到個比較奇怪的現象，union all 上下兩段sql單獨拿出來執行的時間都很快，上下兩段sql都能在50ms左右出結果，但是放一起後就很慢。
如果在這段sql 加個hint /*+ NO_REWRITE */ 以後，union all 這段邏輯一起執行，也能55ms 出結果，感覺是cbo的重寫機制有問題。
但是我不太喜歡加hint來固定住執行計劃，這樣一來會讓cbo受限，如果表的資料發生變化，cbo不能透過統計資訊生成正確的執行計劃。
union all 改寫下：
SELECT task.*, CASE WHEN task.assignee = '1440' THEN '1' ELSE '0' END assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, NVL(form.batch, 0) batch FROM v_bjxx_task task INNER JOIN act_ru_task bl ON bl.proc_inst_id_ = task.BLLC_PROC_INST_ID_ LEFT JOIN form ON ( bl.task_def_key_ = form.nodeid AND bl.proc_def_id_ = form.procdefid AND form.planid = task.PLAN_ID AND form.zzd = '1') WHERE task.assignee = '1440' OR ( task.assignee IS NULL AND EXISTS ( SELECT 1 FROM task_assignee tase WHERE tase.bsc010 = '1440' AND task.id = tase.bjxxid AND task.gwtaskid = tase.gwtaskid ) ) ; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ===================================================================================================== | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | ----------------------------------------------------------------------------------------------------- | | |0 |TEMP TABLE TRANSFORMATION | |3090176 |35539550480 | | | |1 |├─TEMP TABLE INSERT |TEMP1 |2995267 |82943121 | | | |2 |│ └─HASH JOIN | |2995267 |74025340 | | | |3 |│ ├─PX COORDINATOR | |13099764|60671090 | | | |4 |│ │ └─EXCHANGE OUT DISTR |:EX10000 |13099764|42555142 | | | |5 |│ │ └─PX PARTITION ITERATOR | |13099764|1808746 | | | |6 |│ │ └─TABLE FULL SCAN |ACT |13099764|1808746 | | | |7 |│ └─HASH JOIN | |2937089 |4471980 | | | |8 |│ ├─PX COORDINATOR | |128752 |1005639 | | | |9 |│ │ └─EXCHANGE OUT DISTR |:EX20000 |128752 |699778 | | | |10|│ │ └─TABLE FULL SCAN |SX |128752 |11528 | | | |11|│ └─TABLE FULL SCAN |BT |2937089 |2412876 | | | |12|└─UNION ALL | |3090176 |35456607360 | | | |13| ├─HASH RIGHT OUTER JOIN | |3090176 |35456587247 | | | |14| │ ├─PX COORDINATOR | |13940 |69080 | | | |15| │ │ └─EXCHANGE OUT DISTR |:EX30000 |13940 |49143 | | | |16| │ │ └─TABLE FULL SCAN |FORM |13940 |4300 | | | |17| │ └─HASH JOIN | |3090176 |35454536498 | | | |18| │ ├─PX COORDINATOR | |15990828|78905666 | | | |19| │ │ └─EXCHANGE OUT DISTR |:EX40000 |15990828|55128664 | | | |20| │ │ └─PX PARTITION ITERATOR | |15990828|1645439 | | | |21| │ │ └─TABLE FULL SCAN |BL |15990828|1645439 | | | |22| │ └─SUBPLAN SCAN |V_BJXX_TASK |2995267 |35364626635 | | | |23| │ └─SUBPLAN FILTER | |2995267 |35364618707 | | | |24| │ ├─TEMP TABLE ACCESS |VIEW1(TEMP1) |2995267 |120812 | | | |25| │ ├─NESTED-LOOP JOIN | |1 |39 | | | |26| │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |27| │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |28| │ ├─NESTED-LOOP JOIN | |1 |39 | | | |29| │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |30| │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |31| │ ├─NESTED-LOOP JOIN | |1 |39 | | | |32| │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |33| │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |34| │ └─DISTRIBUTED TABLE RANGE SCAN |BX |1 |11692 | | | |35| └─NESTED-LOOP SEMI JOIN | |0 |11934 | | | |36| ├─NESTED-LOOP OUTER JOIN | |0 |11887 | | | |37| │ ├─NESTED-LOOP JOIN | |0 |11860 | | | |38| │ │ ├─SUBPLAN SCAN |V_BJXX_TASK |0 |11807 | | | |39| │ │ │ └─SUBPLAN FILTER | |0 |11807 | | | |40| │ │ │ ├─TEMP TABLE ACCESS |VIEW2(TEMP1) |0 |0 | | | |41| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |42| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |43| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |44| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |45| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |46| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |47| │ │ │ ├─NESTED-LOOP JOIN | |1 |39 | | | |48| │ │ │ │ ├─DISTRIBUTED TABLE GET |T |1 |21 | | | |49| │ │ │ │ └─DISTRIBUTED TABLE GET |T |1 |18 | | | |50| │ │ │ └─DISTRIBUTED TABLE RANGE SCAN|BX |1 |11692 | | | |51| │ │ └─DISTRIBUTED TABLE RANGE SCAN |BL(FQIDX1_TASK_PROC_INST_ID__2)|2 |52 | | | |52| │ └─DISTRIBUTED TABLE RANGE SCAN |FORM(IDX_FORM_PLAN) |1 |27 | | | |53| └─SUBPLAN SCAN |VIEW3 |1 |47 | | | |54| └─DISTRIBUTED TABLE RANGE SCAN |TASE(IDX$$_22880002_FQ) |1 |47 | | | ===================================================================================================== | | Outputs & filters: | | ------------------------------------- | | 0 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])], [UNION([5])], [UNION([6])], [UNION([7])], [UNION([8])], [UNION([9])], [UNION([10])], | | [UNION([11])], [UNION([12])], [UNION([13])], [UNION([14])], [UNION([15])], [UNION([16])], [UNION([17])], [UNION([18])], [UNION([19])], [UNION([20])], [UNION([21])], | | [UNION([22])], [UNION([23])], [UNION([24])], [UNION([25])], [UNION([26])], [UNION([27])], [UNION([28])], [UNION([29])], [UNION([30])], [UNION([31])], [UNION([32])], | | [UNION([33])], [UNION([34])], [UNION([35])], [UNION([36])], [UNION([37])], [UNION([38])], [UNION([39])], [UNION([40])], [UNION([41])], [UNION([42])], [UNION([43])], | | [UNION([44])], [UNION([45])], [UNION([46])], [UNION([47])], [UNION([48])], [UNION([49])], [UNION([50])], [UNION([51])], [UNION([52])], [UNION([53])], [UNION([54])], | | [UNION([55])], [UNION([56])], [UNION([57])], [UNION([58])], [UNION([59])], [UNION([60])], [UNION([61])], [UNION([62])], [UNION([63])], [UNION([64])], [UNION([65])], | | [UNION([66])], [UNION([67])], [UNION([68])], [UNION([69])], [UNION([70])], [UNION([71])], [UNION([72])], [UNION([73])], [UNION([74])], [UNION([75])], [UNION([76])], | | [UNION([77])], [UNION([78])], [UNION([79])], [UNION([80])], [UNION([81])], [UNION([82])], [UNION([83])], [UNION([84])], [UNION([85])], [UNION([86])], [UNION([87])], | | [UNION([88])], [UNION([89])]), filter(nil), rowset=256 | | 1 - output(nil), filter(nil), rowset=256 | | 2 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME], [SX.SXMC], [SX.SXMC_SXBM], | | [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH], [ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | equal_conds([BT.GW_PROC_INST_ID_ = ACT.PROC_INST_ID_]), other_conds(nil) | | 3 - output([ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_], [ACT.PROC_INST_ID_]), filter(nil), rowset=256 | | 4 - output([ACT.ASSIGNEE_], [ACT.ID_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_], [ACT.PROC_INST_ID_]), filter(nil), rowset=256 | | dop=1 | | 5 - output([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | force partition granule | | 6 - output([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), filter([ACT.ASSIGNEE_ = cast('1440', VARCHAR2(1048576 | | )) OR ACT.ASSIGNEE_ IS NULL]), rowset=256 | | access([ACT.ID_], [ACT.PROC_INST_ID_], [ACT.ASSIGNEE_], [ACT.TASK_DEF_KEY_], [ACT.PROC_DEF_ID_]), partitions(p[0-15]) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([ACT.ID_]), range(MIN ; MAX)always true | | 7 - output([BT.ID], [BT.SX_ID], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], [BT.SQZTZJHM], | | [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], [BT.YWFSXD], | | [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], [BT.PLAN_ID], | | [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.GW_PROC_INST_ID_], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], | | [BT.GWZT], [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME], [SX.SXMC], [SX.SXMC_SXBM], | | [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), filter(nil), rowset=256 | | equal_conds([BT.SX_ID = SX.ID]), other_conds(nil) | | 8 - output([SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH], [SX.ID]), filter(nil), rowset=256 | | 9 - output([SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH], [SX.ID]), filter(nil), rowset=256 | | is_single, dop=1 | | 10 - output([SX.ID], [SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), filter(nil), rowset=256 | | access([SX.ID], [SX.SXMC], [SX.SXMC_SXBM], [SX.QLLB], [SX.YWDL], [SX.FWDX], [SX.SXLX], [SX.BLLX], [SX.BJLX], [SX.SSXT], [SX.XZQH]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([SX.ID]), range(MIN ; MAX)always true | | 11 - output([BT.ID], [BT.SX_ID], [BT.GW_PROC_INST_ID_], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], | | [BT.SQZTZJHM], [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], | | [BT.YWFSXD], [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], | | [BT.PLAN_ID], [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], [BT.GWZT], | | [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), filter(nil), rowset=256 | | access([BT.ID], [BT.SX_ID], [BT.GW_PROC_INST_ID_], [BT.SBMC], [BT.SBTJ], [BT.SQZTMC], [BT.SQZTLX], [BT.SQZTWBID], [BT.SQZTAPPID], [BT.SQZTSJHM], [BT.SQZTZJLX], | | [BT.SQZTZJHM], [BT.SQZTDZ], [BT.SQZTYB], [BT.LXRXM], [BT.LXRSJHM], [BT.LXRZJLX], [BT.LXRZJHM], [BT.LXRDZ], [BT.LXRYB], [BT.SDFS], [BT.BEIZHU], [BT.SBSJ], | | [BT.YWFSXD], [BT.YWJBXD], [BT.SBBH], [BT.SBMA], [BT.SLHZDBH], [BT.BJZT], [BT.BJJG], [BT.BJJGMS], [BT.BJSJ], [BT.DZDAID], [BT.BIZID], [BT.BLLC_PROC_INST_ID_], | | [BT.PLAN_ID], [BT.SJGXD], [BT.CTIME], [BT.COPERATOR], [BT.ETIME], [BT.EOPERATOR], [BT.YW_PROC_INST_ID_], [BT.ZTID], [BT.YWGXD], [BT.SLSJ], [BT.YWZT], [BT.GWZT], | | [BT.BATCHID], [BT.PROJID_SZW], [BT.SYSJ], [BT.SXJCJG], [BT.HJJCJG], [BT.CNSXJCJG], [BT.RECEIVE_NAME], [BT.HALL_NAME]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([BT.ID]), range(MIN ; MAX)always true | | 12 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])], [UNION([5])], [UNION([6])], [UNION([7])], [UNION([8])], [UNION([9])], [UNION([10])], | | [UNION([11])], [UNION([12])], [UNION([13])], [UNION([14])], [UNION([15])], [UNION([16])], [UNION([17])], [UNION([18])], [UNION([19])], [UNION([20])], [UNION([21])], | | [UNION([22])], [UNION([23])], [UNION([24])], [UNION([25])], [UNION([26])], [UNION([27])], [UNION([28])], [UNION([29])], [UNION([30])], [UNION([31])], [UNION([32])], | | [UNION([33])], [UNION([34])], [UNION([35])], [UNION([36])], [UNION([37])], [UNION([38])], [UNION([39])], [UNION([40])], [UNION([41])], [UNION([42])], [UNION([43])], | | [UNION([44])], [UNION([45])], [UNION([46])], [UNION([47])], [UNION([48])], [UNION([49])], [UNION([50])], [UNION([51])], [UNION([52])], [UNION([53])], [UNION([54])], | | [UNION([55])], [UNION([56])], [UNION([57])], [UNION([58])], [UNION([59])], [UNION([60])], [UNION([61])], [UNION([62])], [UNION([63])], [UNION([64])], [UNION([65])], | | [UNION([66])], [UNION([67])], [UNION([68])], [UNION([69])], [UNION([70])], [UNION([71])], [UNION([72])], [UNION([73])], [UNION([74])], [UNION([75])], [UNION([76])], | | [UNION([77])], [UNION([78])], [UNION([79])], [UNION([80])], [UNION([81])], [UNION([82])], [UNION([83])], [UNION([84])], [UNION([85])], [UNION([86])], [UNION([87])], | | [UNION([88])], [UNION([89])]), filter(nil), rowset=256 | | 13 - output([TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], | | [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], | | [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], | | [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID], [CASE | | WHEN cast('1440', VARCHAR2(1048576 )) = cast('1440', VARCHAR2(1048576 )) THEN '1' ELSE '0' END], [BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], | | [NVL(FORM.BATCH, cast(0, VARCHAR2(1 BYTE)))]), filter(nil), rowset=256 | | equal_conds([BL.TASK_DEF_KEY_ = FORM.NODEID], [BL.PROC_DEF_ID_ = FORM.PROCDEFID], [FORM.PLANID = TASK.PLAN_ID]), other_conds(nil) | | 14 - output([FORM.BATCH], [FORM.NODEID], [FORM.PROCDEFID], [FORM.PLANID]), filter(nil), rowset=256 | | 15 - output([FORM.BATCH], [FORM.NODEID], [FORM.PROCDEFID], [FORM.PLANID]), filter(nil), rowset=256 | | is_single, dop=1 | | 16 - output([FORM.BATCH], [FORM.NODEID], [FORM.PROCDEFID], [FORM.PLANID]), filter([FORM.ZZD = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([FORM.BATCH], [FORM.NODEID], [FORM.PROCDEFID], [FORM.PLANID], [FORM.ZZD]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([FORM.ID]), range(MIN ; MAX)always true | | 17 - output([TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], | | [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], | | [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], | | [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID], [BL.ID_], | | [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), filter(nil), rowset=256 | | equal_conds([BL.PROC_INST_ID_ = TASK.BLLC_PROC_INST_ID_]), other_conds(nil) | | 18 - output([BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.PROC_INST_ID_]), filter(nil), rowset=256 | | 19 - output([BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.PROC_INST_ID_]), filter(nil), rowset=256 | | dop=1 | | 20 - output([BL.ID_], [BL.PROC_INST_ID_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.NAME_]), filter(nil), rowset=256 | | force partition granule | | 21 - output([BL.ID_], [BL.PROC_INST_ID_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.NAME_]), filter(nil), rowset=256 | | access([BL.ID_], [BL.PROC_INST_ID_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.NAME_]), partitions(p[0-15]) | | is_index_back=false, is_global_index=false, | | range_key([BL.ID_]), range(MIN ; MAX)always true | | 22 - output([TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], | | [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], | | [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], | | [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]), filter(nil), rowset=256 | | access([TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], | | [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], | | [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], | | [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]) | | 23 - output([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.SX_ID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], | | [VIEW1.BT.SXJCJG], [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [subquery(1)], [subquery(2)], [subquery(3)], | | [subquery(4)], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], | | [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | exec_params_([VIEW1.BT.COPERATOR(:0)], [VIEW1.BT.COPERATOR(:1)], [VIEW1.BT.COPERATOR(:2)], [VIEW1.BT.ID(:3)]), onetime_exprs_(nil), init_plan_idxs_(nil), | | use_batch=false | | 24 - output([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], [VIEW1.BT.SXJCJG], | | [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], | | [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]), filter([VIEW1.ACT.ASSIGNEE_ = cast('1440', VARCHAR2(1048576 ))]), rowset=256 | | access([VIEW1.BT.ID], [VIEW1.BT.SX_ID], [VIEW1.BT.SBMC], [VIEW1.BT.SBTJ], [VIEW1.BT.SQZTMC], [VIEW1.BT.SQZTLX], [VIEW1.BT.SQZTWBID], [VIEW1.BT.SQZTAPPID], | | [VIEW1.BT.SQZTSJHM], [VIEW1.BT.SQZTZJLX], [VIEW1.BT.SQZTZJHM], [VIEW1.BT.SQZTDZ], [VIEW1.BT.SQZTYB], [VIEW1.BT.LXRXM], [VIEW1.BT.LXRSJHM], [VIEW1.BT.LXRZJLX], | | [VIEW1.BT.LXRZJHM], [VIEW1.BT.LXRDZ], [VIEW1.BT.LXRYB], [VIEW1.BT.SDFS], [VIEW1.BT.BEIZHU], [VIEW1.BT.SBSJ], [VIEW1.BT.YWFSXD], [VIEW1.BT.YWJBXD], [VIEW1.BT.SBBH], | | [VIEW1.BT.SBMA], [VIEW1.BT.SLHZDBH], [VIEW1.BT.BJZT], [VIEW1.BT.BJJG], [VIEW1.BT.BJJGMS], [VIEW1.BT.BJSJ], [VIEW1.BT.DZDAID], [VIEW1.BT.BIZID], [VIEW1.BT.BLLC_PROC_INST_ID_], | | [VIEW1.BT.PLAN_ID], [VIEW1.BT.SJGXD], [VIEW1.BT.CTIME], [VIEW1.BT.COPERATOR], [VIEW1.BT.ETIME], [VIEW1.BT.EOPERATOR], [VIEW1.BT.GW_PROC_INST_ID_], [VIEW1.BT.YW_PROC_INST_ID_], | | [VIEW1.BT.ZTID], [VIEW1.BT.YWGXD], [VIEW1.BT.SLSJ], [VIEW1.BT.YWZT], [VIEW1.BT.GWZT], [VIEW1.BT.BATCHID], [VIEW1.BT.PROJID_SZW], [VIEW1.BT.SYSJ], [VIEW1.BT.SXJCJG], | | [VIEW1.BT.HJJCJG], [VIEW1.BT.CNSXJCJG], [VIEW1.BT.RECEIVE_NAME], [VIEW1.BT.HALL_NAME], [VIEW1.SX.SXMC], [VIEW1.SX.SXMC_SXBM], [VIEW1.SX.QLLB], [VIEW1.SX.YWDL], | | [VIEW1.SX.FWDX], [VIEW1.SX.SXLX], [VIEW1.SX.BLLX], [VIEW1.SX.BJLX], [VIEW1.SX.SSXT], [VIEW1.SX.XZQH], [VIEW1.ACT.ASSIGNEE_], [VIEW1.ACT.ID_], [VIEW1.ACT.TASK_DEF_KEY_], | | [VIEW1.ACT.PROC_DEF_ID_]) | | 25 - output([T.BSC011]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:12)]), use_batch=false | | 26 - output([T.BSC011], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC011], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :0]) | | 27 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:12 = T.BSC001]) | | 28 - output([T.BSC012]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:14)]), use_batch=false | | 29 - output([T.BSC012], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC012], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :1]) | | 30 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:14 = T.BSC001]) | | 31 - output([T.AAB300]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:16)]), use_batch=false | | 32 - output([T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :2]) | | 33 - output([T.AAB300]), filter(nil), rowset=256 | | access([T.AAB300]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:16 = T.BSC001]) | | 34 - output([BX.BJLY]), filter(nil), rowset=256 | | access([BX.BJLY]), partitions(p0sp[0-7], p1sp[0-7], p2sp[0-7], p3sp[0-7], p4sp[0-7], p5sp[0-7], p6sp[0-7], p7sp[0-7], p8sp[0-7], p9sp[0-7], p10sp[0-7], | | p11sp[0-7], p12sp[0-7], p13sp[0-7], p14sp[0-7], p15sp[0-7], p16sp[0-7], p17sp[0-7], p18sp[0-7], p19sp[0-7], p20sp[0-7], p21sp[0-7], p22sp[0-7], p23sp[0-7], | | p24sp[0-7], p25sp[0-7], p26sp[0-7], p27sp[0-7], p28sp[0-7], p29sp[0-7], p30sp[0-7], p31sp[0-7], p32sp[0-7], p33sp[0-7], p34sp[0-7], p35sp[0-7], p36sp[0-7], | | p37sp[0-7], p38sp[0-7], p39sp[0-7], p40sp[0-7], p41sp[0-7], p42sp[0-7], p43sp[0-7], p44sp[0-7], p45sp[0-7], p46sp[0-7], p47sp[0-7], p48sp[0-7], p49sp[0-7], | | p50sp[0-7], p51sp[0-7], p52sp[0-7], p53sp[0-7], p54sp[0-7], p55sp[0-7], p56sp[0-7], p57sp[0-7], p58sp[0-7], p59sp[0-7], p60sp[0-7], p61sp[0-7], p62sp[0-7], | | p63sp[0-7], p64sp[0-7], p65sp[0-7], p66sp[0-7], p67sp[0-7], p68sp[0-7], p69sp[0-7], p70sp[0-7], p71sp[0-7], p72sp[0-7]) | | is_index_back=false, is_global_index=false, | | range_key([BX.ID], [BX.CTIME]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([BX.ID = :3]) | | 35 - output([TASK.ID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], | | [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], | | [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], | | [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], | | [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], [TASK.SYSJ], | | [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], [TASK.SXMC], | | [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], [TASK.YJSX], | | [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWTASKID], [TASK.GWJDID], [TASK.GWLCID], [CASE | | WHEN cast(NULL, VARCHAR2(255 BYTE)) = cast('1440', VARCHAR2(1048576 )) THEN '1' ELSE '0' END], [BL.ID_], [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], | | [NVL(FORM.BATCH, cast(0, VARCHAR2(1 BYTE)))]), filter(nil), rowset=256 | | conds(nil), nl_params_([TASK.ID(:31)], [TASK.GWTASKID(:32)]), use_batch=false | | 36 - output([TASK.ID], [TASK.GWTASKID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], | | [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], | | [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], | | [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], | | [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], | | [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], | | [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], | | [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWJDID], [TASK.GWLCID], [BL.ID_], | | [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [FORM.BATCH]), filter(nil), rowset=256 | | conds(nil), nl_params_([BL.TASK_DEF_KEY_(:33)], [BL.PROC_DEF_ID_(:34)], [TASK.PLAN_ID(:35)]), use_batch=false | | 37 - output([TASK.ID], [TASK.GWTASKID], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], | | [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], | | [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], | | [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], [TASK.EOPERATOR], | | [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], [TASK.PROJIDSZW], | | [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], [TASK.BJLY], | | [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], [TASK.BLSX], | | [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.ASSIGNEE], [TASK.GWJDID], [TASK.GWLCID], [BL.ID_], | | [BL.NAME_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_]), filter(nil), rowset=256 | | conds(nil), nl_params_([TASK.BLLC_PROC_INST_ID_(:29)]), use_batch=false | | 38 - output([TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], | | [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], | | [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], | | [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]), filter(nil), rowset=256 | | access([TASK.BLLC_PROC_INST_ID_], [TASK.PLAN_ID], [TASK.ID], [TASK.GWTASKID], [TASK.ASSIGNEE], [TASK.SX_ID], [TASK.SBMC], [TASK.SBTJ], [TASK.SQZTMC], | | [TASK.SQZTLX], [TASK.SQZTWBID], [TASK.SQZTAPPID], [TASK.SQZTSJHM], [TASK.SQZTZJLX], [TASK.SQZTZJHM], [TASK.SQZTDZ], [TASK.SQZTYB], [TASK.LXRXM], [TASK.LXRSJHM], | | [TASK.LXRZJLX], [TASK.LXRZJHM], [TASK.LXRDZ], [TASK.LXRYB], [TASK.SDFS], [TASK.BEIZHU], [TASK.SBSJ], [TASK.YWFSXD], [TASK.YWJBXD], [TASK.SBBH], [TASK.SBMA], | | [TASK.SLHZDBH], [TASK.BJZT], [TASK.BJJG], [TASK.BJJGMS], [TASK.BJSJ], [TASK.DZDAID], [TASK.BIZID], [TASK.SJGXD], [TASK.CTIME], [TASK.COPERATOR], [TASK.ETIME], | | [TASK.EOPERATOR], [TASK.GW_PROC_INST_ID_], [TASK.YW_PROC_INST_ID_], [TASK.ZTID], [TASK.YWGXD], [TASK.SLSJ], [TASK.YWZT], [TASK.GWZT], [TASK.BATCHID], [TASK.SXID], | | [TASK.PROJIDSZW], [TASK.SYSJ], [TASK.SXJCJG], [TASK.HJJCJG], [TASK.CNSXJCJG], [TASK.RECEIVE_NAME], [TASK.HALL_NAME], [TASK.BSC011], [TASK.BSC012], [TASK.AAB300], | | [TASK.BJLY], [TASK.SXMC], [TASK.SXMC_SXBM], [TASK.QLLB], [TASK.YWDL], [TASK.FWDX], [TASK.SXLX], [TASK.BLLX], [TASK.BJLX], [TASK.SSXT], [TASK.XZQH], [TASK.JSLX], | | [TASK.BLSX], [TASK.YJSX], [TASK.YJSJ], [TASK.CSSJ], [TASK.YCCSSJ], [TASK.TMSXLX], [TASK.SFDB], [TASK.SXJC], [TASK.GWJDID], [TASK.GWLCID]) | | 39 - output([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.SX_ID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], | | [VIEW2.BT.SXJCJG], [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [subquery(1)], [subquery(2)], [subquery(3)], | | [subquery(4)], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], | | [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [NULL], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]), filter(nil), rowset=256 | | exec_params_([VIEW2.BT.COPERATOR(:4)], [VIEW2.BT.COPERATOR(:5)], [VIEW2.BT.COPERATOR(:6)], [VIEW2.BT.ID(:7)]), onetime_exprs_(nil), init_plan_idxs_(nil), | | use_batch=false | | 40 - output([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], [VIEW2.BT.SXJCJG], | | [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], | | [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]), filter([VIEW2.ACT.ASSIGNEE_ IS NULL]), rowset=256 | | access([VIEW2.BT.ID], [VIEW2.BT.SX_ID], [VIEW2.BT.SBMC], [VIEW2.BT.SBTJ], [VIEW2.BT.SQZTMC], [VIEW2.BT.SQZTLX], [VIEW2.BT.SQZTWBID], [VIEW2.BT.SQZTAPPID], | | [VIEW2.BT.SQZTSJHM], [VIEW2.BT.SQZTZJLX], [VIEW2.BT.SQZTZJHM], [VIEW2.BT.SQZTDZ], [VIEW2.BT.SQZTYB], [VIEW2.BT.LXRXM], [VIEW2.BT.LXRSJHM], [VIEW2.BT.LXRZJLX], | | [VIEW2.BT.LXRZJHM], [VIEW2.BT.LXRDZ], [VIEW2.BT.LXRYB], [VIEW2.BT.SDFS], [VIEW2.BT.BEIZHU], [VIEW2.BT.SBSJ], [VIEW2.BT.YWFSXD], [VIEW2.BT.YWJBXD], [VIEW2.BT.SBBH], | | [VIEW2.BT.SBMA], [VIEW2.BT.SLHZDBH], [VIEW2.BT.BJZT], [VIEW2.BT.BJJG], [VIEW2.BT.BJJGMS], [VIEW2.BT.BJSJ], [VIEW2.BT.DZDAID], [VIEW2.BT.BIZID], [VIEW2.BT.BLLC_PROC_INST_ID_], | | [VIEW2.BT.PLAN_ID], [VIEW2.BT.SJGXD], [VIEW2.BT.CTIME], [VIEW2.BT.COPERATOR], [VIEW2.BT.ETIME], [VIEW2.BT.EOPERATOR], [VIEW2.BT.GW_PROC_INST_ID_], [VIEW2.BT.YW_PROC_INST_ID_], | | [VIEW2.BT.ZTID], [VIEW2.BT.YWGXD], [VIEW2.BT.SLSJ], [VIEW2.BT.YWZT], [VIEW2.BT.GWZT], [VIEW2.BT.BATCHID], [VIEW2.BT.PROJID_SZW], [VIEW2.BT.SYSJ], [VIEW2.BT.SXJCJG], | | [VIEW2.BT.HJJCJG], [VIEW2.BT.CNSXJCJG], [VIEW2.BT.RECEIVE_NAME], [VIEW2.BT.HALL_NAME], [VIEW2.SX.SXMC], [VIEW2.SX.SXMC_SXBM], [VIEW2.SX.QLLB], [VIEW2.SX.YWDL], | | [VIEW2.SX.FWDX], [VIEW2.SX.SXLX], [VIEW2.SX.BLLX], [VIEW2.SX.BJLX], [VIEW2.SX.SSXT], [VIEW2.SX.XZQH], [VIEW2.ACT.ASSIGNEE_], [VIEW2.ACT.ID_], [VIEW2.ACT.TASK_DEF_KEY_], | | [VIEW2.ACT.PROC_DEF_ID_]) | | 41 - output([T.BSC011]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:23)]), use_batch=false | | 42 - output([T.BSC011], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC011], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :4]) | | 43 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:23 = T.BSC001]) | | 44 - output([T.BSC012]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:25)]), use_batch=false | | 45 - output([T.BSC012], [T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC012], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :5]) | | 46 - output(nil), filter(nil), rowset=256 | | access(nil), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:25 = T.BSC001]) | | 47 - output([T.AAB300]), filter(nil), rowset=256 | | conds(nil), nl_params_([T.BSC001(:27)]), use_batch=false | | 48 - output([T.BSC001]), filter([T.AAE100 = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([T.AAE100], [T.BSC001]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([T.BSC010]), range(MIN ; MAX)always true, | | range_cond([T.BSC010 = :6]) | | 49 - output([T.AAB300]), filter(nil), rowset=256 | | access([T.AAB300]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([T.BSC001]), range(MIN ; MAX), | | range_cond([:27 = T.BSC001]) | | 50 - output([BX.BJLY]), filter(nil), rowset=256 | | access([BX.BJLY]), partitions(p0sp[0-7], p1sp[0-7], p2sp[0-7], p3sp[0-7], p4sp[0-7], p5sp[0-7], p6sp[0-7], p7sp[0-7], p8sp[0-7], p9sp[0-7], p10sp[0-7], | | p11sp[0-7], p12sp[0-7], p13sp[0-7], p14sp[0-7], p15sp[0-7], p16sp[0-7], p17sp[0-7], p18sp[0-7], p19sp[0-7], p20sp[0-7], p21sp[0-7], p22sp[0-7], p23sp[0-7], | | p24sp[0-7], p25sp[0-7], p26sp[0-7], p27sp[0-7], p28sp[0-7], p29sp[0-7], p30sp[0-7], p31sp[0-7], p32sp[0-7], p33sp[0-7], p34sp[0-7], p35sp[0-7], p36sp[0-7], | | p37sp[0-7], p38sp[0-7], p39sp[0-7], p40sp[0-7], p41sp[0-7], p42sp[0-7], p43sp[0-7], p44sp[0-7], p45sp[0-7], p46sp[0-7], p47sp[0-7], p48sp[0-7], p49sp[0-7], | | p50sp[0-7], p51sp[0-7], p52sp[0-7], p53sp[0-7], p54sp[0-7], p55sp[0-7], p56sp[0-7], p57sp[0-7], p58sp[0-7], p59sp[0-7], p60sp[0-7], p61sp[0-7], p62sp[0-7], | | p63sp[0-7], p64sp[0-7], p65sp[0-7], p66sp[0-7], p67sp[0-7], p68sp[0-7], p69sp[0-7], p70sp[0-7], p71sp[0-7], p72sp[0-7]) | | is_index_back=false, is_global_index=false, | | range_key([BX.ID], [BX.CTIME]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([BX.ID = :7]) | | 51 - output([BL.ID_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.NAME_]), filter(nil), rowset=256 | | access([BL.ID_], [BL.TASK_DEF_KEY_], [BL.PROC_DEF_ID_], [BL.NAME_]), partitions(p0) | | is_index_back=true, is_global_index=true, | | range_key([BL.PROC_INST_ID_], [BL.ID_]), range(MIN ; MAX), | | range_cond([BL.PROC_INST_ID_ = :29]) | | 52 - output([FORM.BATCH]), filter([FORM.ZZD = cast('1', VARCHAR2(1048576 ))]), rowset=256 | | access([FORM.ID], [FORM.BATCH], [FORM.ZZD]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([FORM.NODEID], [FORM.PLANID], [FORM.PROCDEFID], [FORM.BATCH], [FORM.ID]), range(MIN ; MAX), | | range_cond([:33 = FORM.NODEID], [:34 = FORM.PROCDEFID], [FORM.PLANID = :35]) | | 53 - output(nil), filter(nil), rowset=256 | | access(nil) | | 54 - output([TASE.BJXXID], [TASE.GWTASKID]), filter([TASE.BSC010 = cast('1440', VARCHAR2(1048576 ))]), rowset=256 | | access([TASE.__pk_increment], [TASE.GWTASKID], [TASE.BSC010], [TASE.BJXXID]), partitions(p0) | | is_index_back=true, is_global_index=true, filter_before_indexback[false], | | range_key([TASE.BJXXID], [TASE.GWTASKID], [TASE.__pk_increment]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true, | | range_cond([:31 = TASE.BJXXID], [:32 = TASE.GWTASKID]) | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 392 rows in set (0.351 sec)
我看不太懂ob的執行計劃，放出來是為了讓感興趣的大佬來研究。🧐
改寫完成後，原來這段跑478.27秒的語句，369ms 就能跑出結果，差集比較後也是等價的，整個案例也最佳化完畢。