how to improve insert performance in
insert into mis_fcr_all_txns_susp_temp
(select *
from mis_fcr_all_txns_combi a
where exists
(select acct_no
from mis_fcr_all_txns_fraud3 b
where a.acct_no = b.acct_no) and
a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));
Have you tried running just the select statement ? how long does it take to give you the results ?
I was just wondering if the performance issue is really at the insertion, or it is related to the query that provides the data to insert.
Discuss This Question: 2  Replies