<small>Hello, <br /><br /> Two options for data (>1M), may I know which one better please? <br /><br /> (1) copyOut
(JDBCcopyManager) <br /> t1 into a.csv <br /> delete t2 where pk.cols in t1 <br /> copyIn t2 from a.csv
<br/><br /> (2) setautoCommit(false); <br /> delete t2 where pk.cols in t1; <br /> insert t2 select * from
t1;<br /><br /> Thank you <br /> Emi </small><br />