update OR (delete & insert)

• fernando.pires@gustavsberg.com

  SSC Enthusiast

  Points: 106

  More actions

  October 10, 2003 at 1:14 am

  #82437

  What is the most efficient thing to do if you want to update a table.

  Do a direct update or delete & insert ?

  I have a job that deletes all updated rows an then inserts the new rows (from a AS400 system).

• NPeeters

  SSChampion

  Points: 12536

  More actions

  October 10, 2003 at 2:22 am

  #477813

  Most efficient and best way is to use Update.

  Maybe not only for performance, but just think about it when you are using referential integrity, identity values, ...