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

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.....
...
insert into tb_name values.....

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

truncate table tb_name drop storage;

insert into tb_name select * from ...

The delete operation will be causing tablespace fragments.

There will be decreasing performance of oracle by delete whole table and then insert ...,布布扣,bubuko.com

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

原文：http://blog.csdn.net/ora_raymond/article/details/22822657