Skip to Main Content

Delete all Rows and insert in Oracle can make performance worse?

axdmoraesMar 31 2014 — edited Apr 2 2014

I´m working in a project that I need to make a batch update periodically (every 4 months) from excel files. These excel files doesn´t have keys in theirs rows.

The development of a code that deletes all rows and inserts the whole database again is easier than one that checks in every row its primary key and update if necessary.(sometimes can be a 5 columns key).

My question is: If I delete the all the rows of all tables and insert it again, it will cause tablespace fragmentation and in a future a performce loss?

Is there a way to avoid this?

Thanks in advance


Post Details
Added on Mar 31 2014