I tried to truncate a table that has about 300 records.
fter 5 minutes it was not complete. So I stopped it and used
the delete command instead. The delete took less than 2 seconds.
If truncate is supposed to be faster than the delete, why was the
truncate slow and delet fast. Any ideas why?
Truncate tries to deallocate space, which could take longer, if there is a lot of space to deallocate.
Applications come and go,
but the data remains!
Click Here to Expand Forum to Full Width