DSXchange

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.

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.

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

Right, it does.

Thanks for the information..