Pergunta de entrevista da empresa Findex

Which one is faster? insert or update sql command?

Respostas da entrevista

Sigiloso

16 de fev. de 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

Sigiloso

2 de dez. de 2017

No straight answer, depends on the case

1