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.....With that method, it would 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 as
truncate table tb_name drop storage;
insert into tb_name select * from ...The delete operation will be causing tablespace fragments.
本文讨论了一个周期性数据收集项目中出现的表空间碎片问题,该问题由不断删除和插入数据导致。为解决此问题,建议采用截断表并重新插入的方式替代传统的删除操作,以减少表空间碎片并提升性能。
1626

被折叠的 条评论
为什么被折叠?



