Truncate should be faster.

The delete (DML) hits all the overhead - indexes, triggers,
commits/checkpoints, redo log generation, etc. where the truncate (DDL?)
is non-recoverable - no commits/checkpoints, no redo loggeneration, etc.


It is easier to fix a wrong deletion than it is to fix a wrong
truncation.

Walt <-- could be wrong, it has happened before...

>>> "Gururaj " <oracledba-ezmlmshield-x90604334.[Email address protected]
05/27/04 07:35PM >>>
Hai OracleGurus,

Can u plz tell me whether truncate command or delete command is faster
.
In general whether DDL stmts or DML stmts are faster???

Bye
Guru

Oracle LazyDBA home page