If the below examples were regular tables:

INSERT INTO DATAMART_DBO_PERF_TOTAL_EXTENDED ( DMART_FUND_ID, DMART_CURRENCY, UPD_USER, UPD_DATETIME, ITDA_BM1_RETURN, ITDA_RETURN, ITD_BM1_RETURN, ITD_RETURN, ITD_NET_RETURN, ITDA_NET_RETURN ) VALUES ( @P1, @P2, @P3, @P4, @P5, @P6, @P7,...

Check it again, there should be valid plans now.

I have attached the sqlplans on the first post.

There is a additional "AND e51.PERF_FREQ_CODE = 'D' )" on the first condition in the tweaked query:

--Original

SELECT e51.ENTITY_ID, e51.PERF_FREQ_CODE, e51.END_EFFECTIVE_DATE, e51.STATUS_FLAG, e51.DICTIONARY_ID

FROM PERFORM.DBO.PERF_SUMMARY e51

WHERE ( ( ( ( (...