New answers tagged

13

Is this even true? No, it is an implementation detail. A database may implement a suitable update in place if it so chooses. What are the benefits? Splitting an update into a delete followed by an insert generally makes the implementation simpler. Potential side benefits include the ability to avoid transient key violations in a unique index, by ...



Top 50 recent answers are included