Findex interview question

Which one is faster? insert or update sql command?

Interview Answers

Anonymous

Feb 16, 2019

Insert will be faster because, with update command, the system has to spend time on searching the records need to be updated. with insert command, the system just needs to write new records, does not need to do other operations.

1

Anonymous

Dec 2, 2017

No straight answer, depends on the case

1