Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When does Update become Delene then Insert, Ora817

Re: When does Update become Delene then Insert, Ora817

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Wed, 20 Feb 2002 00:14:40 GMT
Message-ID: <3C72EA80.6FD2CA3E@ci.seattle.wa.us> 





None. Never. Nyet!



Unless you have some burning desire to make a mess of performance and
scalability by messing with indexes and foreign keys. When updating you should
never update the entire row if updating specific fields will do the job.



Daniel Morgan





Kapal Mo wrote:



> What situations should happen for an update be processed by the database as

> a delete then insert?

Received on Tue Feb 19 2002 - 18:14:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US