You are aware that DDL (Data Definition Language) and DML (Data Manipulation
Language) are completely different?

The first id for creating your database and the latter is for manipulating
them (in a nutshell).

Also, truncate permanently deletes the data, can't be rolled back.

Rob.

-----Original Message-----
From: Gururaj
[mailto:oracledba-ezmlmshield-x90604334.[Email address protected]
Sent: 28 May 2004 01:35
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