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

这条语句查询取来特别慢，在 PLSQL 客户端查询时间大概是5min，后来灵机一动，修改其中的LEFT JOIN 为 INNER JOIN，瞬间变为0.1s查询完毕......

1. inner join 与 left join 概念解释