Delete-inserting is more efficent than updating in a common database?

[المشرف العام]

For one table, updating may include traversing each row to searching the difference between the old and new. And Updating the changed rows. But Delete-inserting may looks more simple, it's just need you delete old table and insert a new one.

I wonder what is the shortcoming of delete-inserting, and delete-inserting is more efficent than updating in a common database?

Then I have a big problem in updating shapefile to a geodatabase. There is not a unique key to compare the rows in two different time shapefile.



أكثر...