Lables

Saturday, 14 September 2013

I am loading 1 lakh records into one table1 by using MLOAD and from the same table I am deleting 1 lakh records by using MLOAD. Then which script is faster? Either MLOAD import or MLOAD delete?

Definitely MLOAD delete only. Because it uses only 4 phases(Acquisition phase is not used) and will not use any transient journal. 

No comments:

Post a Comment