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 table then insert rows and Clear table then insert
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.