Truncate resets the highwater mark while delete systematically
removes whatever is being deleted and generates rollback in the
process.

You can rollback a delete since the corresponding Rollback segments
are present but cannot rollback a truncate.Truncate is a lot faster than
a delete and very noticable the bigger the tables.

Not sure I can attempt the second question because those are different
operations and it may be hard to compare processes which are
intrinsically
different (in my opinion)

Michael



"Gururaj " <oracledba-ezmlmshield-x90604334.[Email address protected]
05/27/2004 08:35 PM

To
"LazyDBA.com Discussion" <[Email address protected]
cc

Subject
Truncate Versus Delete - Plz help






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


!-- Virus-Free Mail Using PostMaster Enterprise AvAc & QuickHeal Engine
--!

----------------------------------------------------------------
Bluechip Computer Consultants Pvt Ltd, Bangalore, India
Sent using PostMaster by QuantumLink Communications Pvt Ltd
One Internet account, unlimited personal e-mail addresses
Get your free copy of PostMaster at http://www.postmaster.co.in/


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page