Terry Lee Tucker <terry@xxxxxxxx> writes: > Hello List: > > I've been told that an update to a record is equivalent to a delete > and insert operation. We have a utility written in Perl that brings > into sync certain elements of 50 thousand records on 8 structurally > identical databases. We threw together the script and decided to > just delete the record and re-insert it with the data that was > brought into sync. Now the question: Is it just as fast to do it > this way, or is there some hidden advantage to performing an update? UPDATE will probably be somewhat faster because it's only one SQL statement to parse, plan and execute. -Doug
