Home » SQL & PL/SQL » SQL & PL/SQL » how can say that truncate is faster than delete......
icon4.gif  how can say that truncate is faster than delete...... [message #219792] Fri, 16 February 2007 03:01 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi everyone
how the truncate command is faster than delete command...........
Re: how can say that truncate is faster than delete...... [message #219796 is a reply to message #219792] Fri, 16 February 2007 03:11 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read this
Re: how can say that truncate is faster than delete...... [message #220233 is a reply to message #219792] Mon, 19 February 2007 13:20 Go to previous message
Bill B
Messages: 1502
Registered: December 2004
Senior Member
A truncate will also commit ALL existing existing DML changes, so that they can't be rolled back either.
Previous Topic: Selecting tiff Images from Oracle database (Merged)
Next Topic: insead of trigger
Goto Forum:
  


Current Time: Sun Jan 22 20:28:54 CST 2017

Total time taken to generate the page: 0.06560 seconds