调整了条件位置正常了。
where中的”and tcb.IS_NEWEST = 10041001“改写到第一个left join后正常了。
explain analyze select A.ACTION_TYPE from
(SELECT ta.ACTION_TYPE, tcb.IS_NEWEST, tcb.REFERENCE_ID
FROM t1 ta
LEFT JOIN t2 tcb ON ta.CUSTOMER_BUSINESS_ID = tcb.CUSTOMER_BUSINESS_ID AND ta.CLUE_TYPE = 70241002 AND ta.ACTION_TYPE = 70211001 and tcb.IS_NEWEST = 10041001
LEFT JOIN t3 tpc2 ON ta.CUSTOMER_BUSINESS_ID = tpc2.POTENTIAL_CUSTOMERS_ID AND ta.ACTION_TYPE = 70211007
WHERE 1 = 1 ) A
left join t4 tt ON tt.SOURCE_ID =A.REFERENCE_ID;