Preface

正好在做項目的時候碰到問題，一個復雜的查詢語句

SELECT count(*) FROM RSP_REBU_MAIN rrm 
INNER JOIN RSP_STATE_APPLIED RSA 
ON RRM.REBU_MAIN_ID = RSA.ENTITY_ID AND RSA.STATE_TYPE_CODE IN 
    ( SELECT RST.STATE_TYPE_CODE FROM RSP_STATE_TYPE RST WHERE RST.PARENT_TYPE_ID = 
        ( SELECT RST.STATE_TYPE_ID FROM RSP_STATE_TYPE RST WHERE RST.STATE_TYPE_CODE = 'RBS' ) ) 
INNER JOIN RSP_CUSTOMER RC ON RC.ID = rrm.CUSTOMER_ID 
LEFT JOIN RSP_CUSTOMER_COMPANY_INFO rcci on rcci.id in 
    (select rac.ENTITY_ID from RSP_ASSOCIATION_CUSTOMER rac where RAC.ASSOCIATION_TYPE_CODE = 'CCCA' and rac.record_flag='0' and rrm.CUSTOMER_ID = CUSTOMER_ID) 
WHERE RRM.RECORD_FLAG = 0 order by RRM.CREATED_TIME DESC

這條語句查詢?nèi)硖貏e慢，在 PLSQL 客戶端查詢時間大概是5min，后來靈機一動，修改其中的LEFT JOIN 為 INNER JOIN，瞬間變?yōu)?.1s查詢完畢......

1. inner join 與 left join 概念解釋