Clarification. Are you saying that if I updated all the columns of a row
on a table, then Oracle will treat it as a delete then insert?
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C72EA80.6FD2CA3E_at_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 Wed Feb 20 2002 - 08:50:01 CST
