Hi, Guru,

The truncate command is faster. The caveat is that the process will not generate any logs/redos/archives, etc; so, once it is done, there is no turning back (you cannot rollback).

Hope that helps . . .

Youwoo

-----Original Message-----
From: Gururaj [mailto:oracledba-ezmlmshield-x90604334.[Email address protected]
Sent: Thursday, May 27, 2004 8:35 PM
To: LazyDBA.com Discussion
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