Post reply

update OR (delete & insert)

  • 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).

  • 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, ...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply