Home » SQL & PL/SQL » SQL & PL/SQL » Truncate vs Delete
Truncate vs Delete [message #222913] Tue, 06 March 2007 23:30 Go to next message
lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune
Junior Member
Hi All,

Can anyone suggest , truncate is faster or delete is faster to operate, when deleting the rows in a table .if it is why it is so.Please help me out.

thanks in advance,
Re: Truncate vs Delete [message #222917 is a reply to message #222913] Tue, 06 March 2007 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
TRUCATE; 'cuz no rollback.
Re: Truncate vs Delete [message #222933 is a reply to message #222917] Wed, 07 March 2007 00:23 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hi All,

Can anyone suggest , search is faster or post new thread is faster to operate, when asking a common question .if it is why it is so.Please help me out.

thanks in advance,
Re: Truncate vs Delete [message #222937 is a reply to message #222933] Wed, 07 March 2007 00:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
rleishman wrote on Wed, 07 March 2007 07:23
Hi All,

Can anyone suggest , search is faster or post new thread is faster to operate, when asking a common question .if it is why it is so.Please help me out.

thanks in advance,


lol

plz, u have 2 say is it urgent?
Re: Truncate vs Delete [message #222941 is a reply to message #222937] Wed, 07 March 2007 00:37 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do ask your dealer to change the mixture ./fa/1986/0/
Re: Truncate vs Delete [message #222942 is a reply to message #222913] Wed, 07 March 2007 00:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone suggest , search is faster or post new thread is faster to operate, when asking a common question
NO!
Re: Truncate vs Delete [message #223023 is a reply to message #222913] Wed, 07 March 2007 04:08 Go to previous messageGo to next message
chinagjj2008
Messages: 1
Registered: March 2007
Junior Member

速度上 truncate 〉delete 因为 truncate 操作不写日志,而delete操作写日志,又由于truncate操作不进行rollback,所以速度上要比delete快

babelfish translation
In speed truncate > delete because the truncate operation does not write the diary <dictionary?>, but the delete operation writes the diary <dictionary?>, also because the truncate operation does not carry on rollback, therefore in the speed must be quicker than delete


[Mod-edit]Added babelfish translation. Next time, post in English or see your message deleted.

[Updated on: Wed, 07 March 2007 05:57] by Moderator

Report message to a moderator

Re: Truncate vs Delete [message #223029 is a reply to message #223023] Wed, 07 March 2007 04:49 Go to previous message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member

And You have to post your message in experts forum.

Rgds
Hari Krishna
Previous Topic: problem with "like" predicate
Next Topic: Problem in Creating a View
Goto Forum:
  


Current Time: Thu Dec 08 06:19:55 CST 2016

Total time taken to generate the page: 0.32106 seconds