执行计划不一样.dat (16.5 KB)
新老版本执行计划不同的点。后面用 hint 解决的:
explain
SELECT
/*+ LEADING(rs,om,ro) */
count(1) AS refundCount
FROM
TCSceneryMemberOrderAll.RefundSupplier rs
INNER JOIN
TCSceneryMemberOrderAll.OrderMain om
ON
om.SerialID = rs.SerialID
INNER JOIN
TCSceneryMemberOrderAll.RefundOrder…