oracle 相同的sql执行两次 执行计划会不一样吗,同一条sql语句，动态执行和单独执行的执行计划会不同？...

没有使用绑定变量。

语句如下：

INSERT INTO JHJG

(BRANCH_NO,

BUSINESS_TYPE_CD,

BUSINESS_PK_DESC,

NON_ACCO_CHK_RULE_CD,

IS_PASSED_IND,

CUSTOMER_PK_INFO,

NON_ACCO_CHK_RESLT_TYPE_CD,

HANDLING_ORG_NO,

HANDLING_USER_NO,

customer_no,

chinese_name,

agreement_no,

product_cd,

amount,

currency_cd)

SELECT       m.BRANCH_NO,

m.BUSINESS_TYPE_CD,

m.BUSINESS_PK_DESC,

m.NON_ACCO_CHK_RULE_CD,

m.IS_PASSED_IND,

m.CUSTOMER_PK_INFO,

m.NON_ACCO_CHK_RESLT_TYPE_CD,

m.HANDLING_ORG_NO,

m.HANDLING_USER_NO,

m.customer_no,

m.chinese_name,

m.agreement_no,

m.product_cd,

m.amount,

m.currency_cd

FROM (SELECT decode(substr(c.HANDLING_ORG_NO, 1, 3) || '000000',

'000000',

'-9999',

substr(c.HANDLING_ORG_NO, 1, 3) || '000000') AS BRANCH_NO,

'1' AS BUSINESS_TYPE_CD,

'B_MI_CP_COLLATERAL,' || a.guaranty_id || ',' ||

a.source_system_id AS BUSINESS_PK_DESC,

'DYHT0002' AS NON_ACCO_CHK_RULE_CD,

'0' AS IS_PASSED_IND,

b.CUSTOMER_NO || ',' || b.source_system_id AS CUSTOMER_PK_INFO,

'3' AS NON_ACCO_CHK_RESLT_TYPE_CD,

c.handling_org_no AS HANDLING_ORG_NO,

c.handling_user_no AS HANDLING_USER_NO,

f.customer_no AS customer_no,

f.chinese_name AS chinese_name,

c.agreement_no AS agreement_no,

c.product_cd AS product_cd,

c.amount AS amount,

c.currency_cd AS currency_cd,

row_number() over(PARTITION BY A.guaranty_id, A.source_system_id ORDER BY b.agreement_no DESC) rn

FROM COLLA a

LEFT JOIN CURLN b ON a.guaranty_id =

b.guaranty_id

AND a.Source_System_id =

b.Source_System_id

AND b.END_DATE =

TO_DATE('99991231',

'YYYYMMDD')

INNER JOIN AGREE c ON c.agreement_no =

b.agreement_no

INNER JOIN CUSTINFO f ON c.customer_no =

f.customer_no

----

WHERE a.collateral_type_cd IN

('01', '02', '03', '04', '05', '06')

AND b.valid_ind = '1'

AND B.GUARANTY_TYPE_CD IN ('01', '02', '07')

AND f.END_date = TO_DATE('99991231', 'YYYYMMDD')

AND EXISTS

(SELECT 1

FROM TMPR3 r

WHERE r.agreement_no = c.agreement_no)

AND (a.eval_value IS NULL OR a.eval_value < 0)) M

WHERE m.rn = 1