帮忙优化SQL!提速就结贴!
select c.tskillgrp_code, nvl(sum(case when b.composite_timeout='0' and b.handle_timeout = '0' and b.reply_timeout = '0' and b.archive_timeout = '0' then 1 end),0) notTimeoutCount,nvl(sum(case when b.composite_timeout = '1' then 1 else 0 end),0) compositeCount,nvl(sum(case when b.handle_timeout = '1' then 1 else 0 end),0) handleCount,nvl(sum(case when b.sreply_timeout = '1' then 1 else 0 end),0) replyCount,nvl(sum(case when b.archive_timeout = '1' then 1 else 0 end),0) archiveCount,nvl(count(t.case_no),0) allCount from table_one t,table_two b,table_three c where t.case_no = b.case_no and t.case_no = c.case_no and c.deal_flag = '3' group by c.tskillgrp_code
每个表中都有三百万以上的数据,所以关联查询起来相当慢,所以请帮忙优化一下,谢谢!
------解决方案--------------------
select c.tskillgrp_code,
nvl(sum(case
when b.composite_timeout = '0' and b.handle_timeout = '0' and
b.reply_timeout = '0' and b.archive_timeout = '0' then
1
end),
0) notTimeoutCount,
nvl(sum(case
when b.composite_timeout = '1' then
1
else
0
end),
0) compositeCount,
nvl(sum(case
when b.handle_timeout = '1' then
1
else
0
end),
0) handleCount,
nvl(sum(case
when b.sreply_timeout = '1' then
1
&nb