Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate with or without REUSE option

134958Feb 2 2005 — edited Feb 2 2005
The application I am working on is truncating millions of rows each week and inserting similar amount of rows each time.

Is there a performance advantage to use the REUSE STORAGE option over the DROP STORAGE OPTION?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2005
Added on Feb 2 2005
1 comment
356 views