Delete Vs Truncate
HI
Delete and truncate both are useful in deleting the records, however when ever you had issued an delete clause it just marks the records in the table as deleted, the memory(bytes) will be the same,at this point you can perform commit and rollback transaction statement controls. where as truncate clause removes the entire records. the major advantage of truncate clause is it actually removes the records from the table so it releases memory. here you can't peform the transaction statement controls. hope this will help for you.
VJ
|