-
Hi Peeps,
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.
http://otn.oracle.com/docs/products/...7a.htm#2067573
______________________
Applications come and go,
but the data remains!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|