>> 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? > >They will generate a comparable amount of garbage, but I think updating >the existing records is better than delete + insert, especially if there >are also foreign key references to those records.
Agreed with Mark. From a logical point of view, if you want to modify data, update it. Something else doesn't make sense. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!