Delete truncate
DDL command - you can roll back DDL command - can not roll back
Slow as maintain redolog Fast as do not maintain
redologyou can provide condition you can
not provide condition
Hope it will help
Cheers
-Neeraj
-----Original Message-----
From: Sumalatha Makam (Associate)
[mailto:oracledba-ezmlmshield-x90105282.[Email address protected]
Sent: Wednesday, October 10, 2007 3:46 PM
To: LazyDBA Discussion
Subject: Difference & performance of Delete and Truncate
Hi all...
Please can any one explain the difference between Delete and truncate in
SQL
How does it affect the performance...???
Is there any clause named "Compensate" in SQL
Regards
Sumalatha M
DISCLAIMER:
This message (including attachment if any) is confidential and may be
privileged. If you have received this message by mistake please notify
the sender by return e-mail and delete this message from your system.
Any unauthorized use or dissemination of this message in whole or in
part is strictly prohibited.
E-mail may contain viruses. Before opening attachments please check them
for viruses and defects. While MindTree Consulting Limited (MindTree)
has put in place checks to minimize the risks, MindTree will not be
responsible for any viruses or defects or any forwarded attachments
emanating either from within MindTree or outside.
Please note that e-mails are susceptible to change and MindTree shall
not be liable for any improper, untimely or incomplete transmission.
MindTree reserves the right to monitor and review the content of all
messages sent to or from MindTree e-mail address. Messages sent to or
from this e-mail address may be stored on the MindTree e-mail system or
else where.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.
-----------------------------------------------------------------------------------------------------------------------
Oracle LazyDBA home page