OceanBase 金融專案最佳化案例(union all 改寫)

小至尖尖發表於2024-07-17

在工單系統上看到有一條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 就能跑出結果,差集比較後也是等價的,整個案例也最佳化完畢。

相關文章