Subject Re: What is better: UPDATE or DELETE + INSERT?
> ---In, <brucedickinson@...> wrote :
> 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?

  Think about indices:
- when you do UPDATE, Firebird will add new index entries only for those indices which keys was changed;
- when you do DELETE and INSERT, Firebird will add new index entries for every index in relation.