select c.job_command,c.job_command_content,c.zero_balance,c.zero_code,
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=0 and mc.Confirm_Flag=1) as apply_amt,
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=1 and mc.Confirm_Flag=1) as payment_amt,
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=0 and mc.Confirm_Flag=1)
-(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=1 and mc.Confirm_Flag=1) as use_amt
from t_mim_job_command c
where c.ZERO_BALANCE=0
这个我要怎么优化?数据库Oracle优化
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=0 and mc.Confirm_Flag=1) as apply_amt,
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=1 and mc.Confirm_Flag=1) as payment_amt,
(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=0 and mc.Confirm_Flag=1)
-(select sum(ACCEPT_PAYMENT_AMT) from t_fim_contract_amt_fact mc where mc.CONTRACT_PAY_TYPE=1 and mc.Confirm_Flag=1) as use_amt
from t_mim_job_command c
where c.ZERO_BALANCE=0
这个我要怎么优化?数据库Oracle优化
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货