100w的数据量 查一下要几乎1分钟 不可想象 怎么优化下啊?楼主菜鸟
select case
when a.type = '1' then
'存款'
when a.type = '2' then
'存款'
when a.type = '3' then
'贷款'
when a.type = '4' then
'贷款'
when a.type = '5' then
'贷款'
when a.type = '6' then
'贷款'
else
'无数据'
end as type,
a.begin_avg,
a.org_id,
b.org_name,
a.manager_id,
c.group_name as manager_name,
d.cons_desc,
a.account_no,
a.currency_code,
a.ratio,
kmh,
a.customer_id,
f.customer_name,
case
when e.is_sx = '2' then
'重点'
else
'非重点'
end as is_sx,
a.Acc_typ,
a.Store,
a.amass,
a.bal_avg,
a.balance
from asses_jymgr_mx a, bank_list b,
outer std_group c,
outer d_cons d,
outer customer_list_gj e,
outer customer_list f
where a.org_id = b.org_id
and a.manager_id = c.group_id
and a.manager_cons = d.cons_id
and a.customer_id = e.customer_id
and a.customer_id = f.customer_id
and a.year = 2012
and a.month = 11
and a.acc_typ = '1'
select case
when a.type = '1' then
'存款'
when a.type = '2' then
'存款'
when a.type = '3' then
'贷款'
when a.type = '4' then
'贷款'
when a.type = '5' then
'贷款'
when a.type = '6' then
'贷款'
else
'无数据'
end as type,
a.begin_avg,
a.org_id,
b.org_name,
a.manager_id,
c.group_name as manager_name,
d.cons_desc,
a.account_no,
a.currency_code,
a.ratio,
kmh,
a.customer_id,
f.customer_name,
case
when e.is_sx = '2' then
'重点'
else
'非重点'
end as is_sx,
a.Acc_typ,
a.Store,
a.amass,
a.bal_avg,
a.balance
from asses_jymgr_mx a, bank_list b,
outer std_group c,
outer d_cons d,
outer customer_list_gj e,
outer customer_list f
where a.org_id = b.org_id
and a.manager_id = c.group_id
and a.manager_cons = d.cons_id
and a.customer_id = e.customer_id
and a.customer_id = f.customer_id
and a.year = 2012
and a.month = 11
and a.acc_typ = '1'
解决方案 »
- Oracle文档里这样的图表符号是什么意思,在那个官方Oracle文档里有介绍这样图表的?
- oracle有类似sql server的事件探查器么?就是程序前台操作所执行的sql都记录下来了。
- 修改计算机名后,OracleDBConsole不能启动
- 求助:关于oracle9i的安装问题(急)
- 问一个查询的题目
- 请问我的ORACLE数据库归档日志文件存放在哪里?
- 菜鸟面试急需解决的问题!
- 请教: 我的oracle9i装完了, 可是系统盘大了5个G, 已经没有空间用了. 不解!!
- oracle9i for windows2000,中有svrmgrl命令吗??
- plsql中如何删除和移动指定文件。
- oracle全文检索
- 【非常纠结】linux上入库Oracle乱码问题
from asses_jymgr_mx a,
outer customer_list_gj e,
bank_list b,
outer std_group c,
outer d_cons d,
outer customer_list f
where a.org_id = b.org_id
and a.year = 2012
and a.month = 11
and a.acc_typ = '1'
and a.customer_id = e.customer_id
and a.manager_id = c.group_id
and a.manager_cons = d.cons_id
and a.customer_id = f.customer_id
具体的 sql 我也就 不写了 ,给你 个思路。
and a.month = 11
and a.acc_typ = '1' 这三条提前 看看year 和month 是数字类型吗, 如果是字符串 的话加上单引号会快的。 a 表是100w b表有多少数据?