Truncate table then insert rows and Clear table then insert

dodda · Post by **dodda** » Fri Oct 23, 2009 10:53 am

Hi All,

Can anyone provide some information about Truncate table then insert rows and Clear table then insert rows in oracle stage.

And kindly let me know will give better performance if the target table has more number of rows.

I appreciate your help.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 23, 2009 11:01 am

Truncate issues a TRUNCATE TABLE statement, which is non-transactional. Clear (probably) issues a DELETE command, which will be logged in the transaction log. As a general rule truncate is faster.

chulett · Post by **chulett** » Fri Oct 23, 2009 11:19 am

ray.wurlod wrote:Clear (probably) issues a DELETE command, which will be logged in the transaction log.

Right, it does.

dodda · Post by **dodda** » Sat Oct 24, 2009 8:23 am

Thanks for the information..