Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Truncate before drop. Any real improvement?
Hello,
Due to testing with some really big tables (creating, deleting,
altering and updating involved) sometimes it's needed to drop the full
table and start again.
AFAIK, "truncate" is the best way to remove all rows in a table,
besides, it does not generate undo information.
So, does it make any sense to truncate a big table before dropping it? Is there any improvement in deleting a table previously truncated?
Thanks in advance. Received on Thu Sep 14 2006 - 04:33:57 CDT
![]() |
![]() |