Hi all, I have a simple table with a few million records. Quite often I will have to update some non key field in a record. If that record does not exist, I have to insert it. So I have to select the record first. If it doesn't exist, insert new record. If it does exist, update it. I can also always delete the record first and then always do the insert. Which would be fastest in general? And in case there are many more inserts than updates? Thanks for your tips on this!