One of my colleague was asking the other day why we have to use %TruncateTable instead of DELETE. The below pb line has the answer.
- On all databases, the use of %TruncateTable causes an implicit commit.
- The rows deleted by this command, and any other pending database updates, are all committed.
- Execution is faster than either of the SQL statements.
Post a Comment