想請教下，一個sql陳述句中有很多聚合函式和子查詢，應該怎么處理讓查詢速度變快
SELECT
IFNULL(SUM(o.BILL_AMOUNT),0) as orderAmount,
IFNULL(SUM(IF ( o.`STATUS` = '40', o.BILL_AMOUNT, 0 )),0) as cancelOrderAmount,
IFNULL(sum(l.LOAN_AMOUNT),0) as loanAmount,
IFNULL(sum( IF ( l.`STATUS` = '10', l.LOAN_AMOUNT, 0)),0) as loanUndoneAmount,
IFNULL(sum( IF ( l.`STATUS` = '30', l.LOAN_AMOUNT, 0 )),0) as loanDoneAmount,
count(*) as billNumber
FROM yqt_order_info o
inner join sys_app_profile ssp ON ssp.app_id = o.loan_app_id
LEFT JOIN yqt_loan_info l ON l.order_id = cast(o.id as char) AND l. STATUS != '0'
where 1=1
and o.ID not in
(select oinfo.ID from yqt_order_info oinfo
inner join yqt_product_info product on product.product_code=oinfo.loan_type
where oinfo.status='40' and product.cancel_amt_valid ='N')
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/265218.html
標籤：疑難問題