how to improve insert performance in
insert into mis_fcr_all_txns_susp_temp
from mis_fcr_all_txns_combi a
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));
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!