OceanBase 金融项目优化案例(union all 改写)

SELECTtask.*, sc01.aab300 bjsjjg, (SELECTsc05.bsc012FROMsc05WHEREtask.coperator= sc05.bsc010) coperatorName, (SELECTsc01.aab300FROMsc01WHEREtask.ywgxd= sc01.bsc001) ywjbbm, (SELECTsc05.bsc012FROMsc05WHEREtask.assignee= sc05.bsc010) qlrmc, (SELECTv_bjxx_oversee.OVERSEE_TYPEFROMv_bjxx_overseeWHEREtask.ID= v_bjxx_oversee.Bjxx_Id) overdueStatus, (SELECTTRUNC(v_bjxx_oversee.CNSJ-SYSDATE,2)FROMv_bjxx_overseeWHEREtask.ID= v_bjxx_oversee.Bjxx_Id) surplusDaysFROM(SELECTtask.*,CASEWHENtask.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) batchFROM v_bjxx_task taskINNERJOIN act_ru_task bl ONbl.proc_inst_id_=task.BLLC_PROC_INST_ID_LEFTJOINformON ( bl.task_def_key_ =form.nodeidANDbl.proc_def_id_=form.procdefidANDform.planid=task.PLAN_IDANDform.zzd='1')WHEREtask.assignee='1440'OR ( task.assignee ISNULLANDEXISTS(SELECT1FROM task_assignee tase WHEREtase.bsc010='1440'ANDtask.id=tase.bjxxidANDtask.gwtaskid= tase.gwtaskid ) ) ) task, sc01, gwpzWHEREgwpz.planid=task.PLAN_IDANDgwpz.gwjdid=task.gwjdidANDgwpz.bllcjdid=task.task_def_key_ANDgwpz.bllcyqid=task.proc_def_id_ANDgwpz.gwlcid=task.gwlcidANDtask.batch=0ANDtask.ywfsxd=sc01.bsc001(+);

SELECTtask.*,'1' assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, (SELECTnvl(form.batch,0) batch FROMformWHEREbl.task_def_key_=form.nodeidANDbl.proc_def_id_=form.procdefidANDform.planid=task.PLAN_IDANDform.zzd='1' ) batchFROM v_bjxx_task task, act_ru_task blWHEREbl.proc_inst_id_=task.BLLC_PROC_INST_ID_ANDtask.assignee='1440'UNIONallSELECT task.*,'0' assigned, bl.id_ taskid, bl.name_ name, bl.task_def_key_, bl.proc_def_id_, (SELECTnvl(form.batch,0) batch FROMformWHEREbl.task_def_key_=form.nodeidANDbl.proc_def_id_=form.procdefidANDform.planid=task.PLAN_IDANDform.zzd='1' ) batchFROM v_bjxx_task task, (SELECTDISTINCT tase.bjxxid, tase.gwtaskid, tase.bsc010, tase.bsc001 FROM task_assignee tase) ta, act_ru_task blWHEREtask.id=ta.bjxxidANDtask.gwtaskid=ta.gwtaskidANDtask.assigneeisnullANDbl.proc_inst_id_=task.BLLC_PROC_INST_ID_ANDta.bsc010='1440';+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|QueryPlan|+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|=====================================================================================================|||ID|OPERATOR|NAME|EST.ROWS|EST.TIME(us)|||----------------------------------------------------------------------------------------------------- |||0|TEMPTABLETRANSFORMATION||3090176|35717409065||||1|├─TEMPTABLEINSERT|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|│ │ └─TABLEFULLSCAN|ACT|13099764|1808746||||7|│ └─HASH JOIN||2937089|108316902||||8|│ ├─TABLEFULLSCAN|SX|128752|11528||||9|│ └─PX COORDINATOR ||2937089|107251909||||10|│ └─EXCHANGE OUT DISTR |:EX20000|2937089|75006584||||11|│ └─TABLEFULLSCAN|BT|2937089|2412876||||12|└─UNIONALL||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| │ │ │ └─TABLEFULLSCAN|BL|15990828|1645439||||19| │ │ └─SUBPLAN SCAN |V_BJXX_TASK|2995267|35364626635||||20| │ │ └─SUBPLAN FILTER ||2995267|35364618707||||21| │ │ ├─TEMPTABLEACCESS|VIEW1(TEMP1)|2995267|120812||||22| │ │ ├─NESTED-LOOPJOIN||1|39||||23| │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||24| │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||25| │ │ ├─NESTED-LOOPJOIN||1|39||||26| │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||27| │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||28| │ │ ├─NESTED-LOOPJOIN||1|39||||29| │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||30| │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||31| │ │ └─DISTRIBUTEDTABLE RANGE SCAN |BX|1|11692||||32| │ └─DISTRIBUTEDTABLE RANGE SCAN |FORM(IDX_FORM_PLAN)|1|25||||33| └─SUBPLAN FILTER ||0|11932||||34|├─NESTED-LOOPJOIN||0|11907||||35| │ ├─NESTED-LOOPJOIN||0|11855||||36| │ │ ├─SUBPLAN SCAN |V_BJXX_TASK|0|11807||||37| │ │ │ └─SUBPLAN FILTER ||0|11807||||38| │ │ │ ├─TEMPTABLEACCESS|VIEW2(TEMP1)|0|0||||39| │ │ │ ├─NESTED-LOOPJOIN||1|39||||40| │ │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||41| │ │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||42| │ │ │ ├─NESTED-LOOPJOIN||1|39||||43| │ │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||44| │ │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||45| │ │ │ ├─NESTED-LOOPJOIN||1|39||||46| │ │ │ │ ├─DISTRIBUTEDTABLEGET|T|1|21||||47| │ │ │ │ └─DISTRIBUTEDTABLEGET|T|1|18||||48| │ │ │ └─DISTRIBUTEDTABLE RANGE SCAN|BX|1|11692||||49| │ │ └─SUBPLAN SCAN |TA|1|47||||50| │ │ └─HASH DISTINCT||1|47||||51| │ │ └─DISTRIBUTEDTABLE RANGE SCAN|TASE(IDX$$_22880002_FQ)|1|47||||52| │ └─DISTRIBUTEDTABLE RANGE SCAN |BL(FQIDX1_TASK_PROC_INST_ID__2)|2|52||||53|└─DISTRIBUTEDTABLE 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])|+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+396rowsinset(0.217sec)