Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

Which one is faster DELETE/TRUNCATE?
Truncante is more faster than delete because when we delete the records from the database, database has to perform 2 actions.
> Delete from the database
> Write the deleted records into "rollback"  
segments. But incase of "Truncate" the second activity is not required.It is faster than becouse truncate is a ddl command so it does not produce any rollback information and the storage space is released while the delete command is a dml command and it produces rollback information too and space is not deallocated using delete command.
Posted By: Name:Rajesh Kr URL: Which one is faster DELETE/TRUNCATE?