Subject What is better: UPDATE or DELETE + INSERT?
Author
Hello,

I need to rebuild some records in my database. I have to choices:

1. Firstly I delete set of records and then insert new ones.
2. I update the existing ones.

What solution is preferable? Will scenerio number 1. cause more garbage in database and decrease its performance?


Thank you.