Re: Truncate before drop. Any real improvement?

Franky R. wrote:
> 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.

If you are going to DROP the table, TRUNCATE doesn't make sense at all, as in both cases records are not deleted, and no redo is generated.

-- 
Sybrand Bakker
Senior Oracle DBA