INNER JOIN P2P_Loan_CommonFlowBiz cb ON cb.Biz_ID = bpipi.Biz_ID
INNER JOIN P2P_Loan_Info pli ON pli.LoanID = cb.CommonFlow_ID
INNER JOIN P2P_Loan_car_Info plc ON plc.Loanid = pli.LoanID
INNER JOIN dbo.P2P_Loan_Process_Info lpi ON lpi.LoanID = plc.LoanID
LEFT JOIN ( SELECT SUM(LR.plan_repay_benxi) '總計逾期租金' ,
MIN(LCO.LoanTerm) '首期逾期期數' ,
lR.LoanID
FROM P2P_Loan_Repayment AS LR
INNER JOIN P2P_Loan_ChargeOverdue AS LCO ON LR.LoanID = LCO.LoanID
AND LR.term_preNum = LCO.LoanTerm
AND LR.PaymentFlag = 1
GROUP BY LR.LoanID
) zongji ON zongji.LoanID = pli.LoanID
LEFT JOIN ( SELECT OverdueDays ,
co.LoanID
FROM P2P_Loan_ChargeOverdue co
INNER JOIN ( SELECT MIN(lr.term_preNum) term_preNum ,
lr.LoanID
FROM P2P_Loan_Repayment AS LR
INNER JOIN P2P_Loan_ChargeOverdue
AS LCO ON LCO.LoanID = LR.LoanID
AND LCO.LoanTerm = LR.term_preNum
AND LR.PaymentFlag = 1
GROUP BY lr.LoanID
) shouqitianshu ON shouqitianshu.LoanID = co.LoanID
AND shouqitianshu.term_preNum = co.LoanTerm
) uu ON uu.LoanID = pli.LoanID
這兩個left join 里面的子查詢 單獨查詢都只要1秒鐘 但是 和其他表left join 后 要幾十秒甚至一分鐘以上 這個怎么解決
uj5u.com熱心網友回復：
用臨時表，保存到臨時表，然后 join 臨時表uj5u.com熱心網友回復：
我這個用視圖 查的 沒法用臨時表吧
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/86257.html
標籤：基礎類
下一篇：這是怎么回事？為什么輸入會例外