There will be decreasing performance of oracle by delete whole table and then insert...

Source: Internet
Author: User

There is a project that need collecting periodically (2 months) data into one table and then exporting it as excel file. The table is a temporary table, the app do that

Delete from tb_name; insert into tb_name values .....

With that method, it wocould be causing more and more tablespace fragments, and make the performance decresing.

In other to avoid this disadvantage influences, I suggest programer modify the app

Truncate table tb_name drop storage; insert into tb_name select * from...

The delete operation will be causing tablespace fragments.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.