TRUNCATE IS FASTER THEN DELETE AS THERE IS NO LOGGING
----- Original Message -----
From: "Gururaj " <oracledba-ezmlmshield-x90604334.[Email address protected]
To: "LazyDBA.com Discussion" <[Email address protected]
Sent: Friday, May 28, 2004 6:05 AM
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