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 -> update Is Oracle update a direct update in-place?

update Is Oracle update a direct update in-place?

From: Fengqing Zhou <zhouf_at_rintintin.Colorado.EDU>
Date: 1997/01/06
Message-ID: <5arfgu$h4c@lace.colorado.edu>#1/1 







Hi!



Sybase has direct update in-place and non-direct update in-place.



Nondirect update in-place means a update is a DELETE followed by
an INSERT. 



Direct update in-place means the record updated still keeps its original 
physical location after update.



My understanding for Oracle update is:


All updates in Oracle are "Sybase direct update in-place".



Am I wrong?



TIA,

Received on Mon Jan 06 1997 - 00:00:00 CST












Original text of this message













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