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