SQL脚本优化方案.docxVIP

数据库性能优化方案 脚本优化 优化前SQL SQL脚本 select tb.c_id, tb.c_task_cde, tb.c_task_nme, tb.c_clnt_nme, tb.c_mobile, tb.c_city, to_char(ta.c_task_tm, yyyy-mm-dd hh24:mi:ss) as c_task_tm, tb.c_province, (select distinct name from sys_user where loginname = ta.c_task_found) as c_task_found, ta.c_task_nature_mrk, (select distinct name from sys_user where loginname = ta.c_task_appoint_nme) as c_task_appoint_nme, tb.c_clnt_cde, tb.c_call_mrk, tb.c_ser_mrk, hccs.src as c_task_aount, rwpfcs.str as history_track_count, to_char(tb.t_crt_tm, yyyy-mm-dd hh24:mi:ss) as t_crt_tm from tb_task_base tb, tb_task_assign ta, (select tkb.c_mobile, (select count(tchr.c_task_cde) from tb_call_history_record tchr where tchr.c_del = 1 and tchr.c_mobile = tkb.c_mobile and tchr.c_task_cde = tkb.c_task_cde and tchr.c_clnt_cde = tkb.c_clnt_cde) as src, rowid as rowcode from tb_task_base tkb where tkb.c_del = 1 and tkb.c_task_mrk = 1) hccs, (select ttbs.c_id, (select count(tods.c_task_cde) from tb_operate_del tods where tods.c_del = 1 and tods.c_task_cde = ttbs.c_task_cde and tods.c_mobile = ttbs.c_mobile and tods.c_operate_mrk = 8 and tods.c_fk_task_id = ttbs.c_id) as str, rowid as rowcode from tb_task_base ttbs where ttbs.c_del = 1 and ttbs.c_task_mrk = 1) rwpfcs where tb.c_del = 1 and ta.c_del = 1 and rwpfcs.rowcode = tb.rowid and ta.c_fk_task_id = tb.c_id and hccs.rowcode = tb.rowid and tb.c_task_mrk in (1, 8) and exists (select null from sys_duty d, sys_user u,