Re: Updating by RowId when alread has fetched the row....

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 05 Mar 2004 06:28:55 +0100
Message-ID: <tt3g40lja6c7aci3dv77uc182diu5pdbed@4ax.com>

On 4 Mar 2004 14:32:37 -0800, danny.icha_at_usa.net (Daniel) wrote:

>Hi there....
>A simple question...
>Using OCI I already has fetched a row (using a WHERE clause) **FOR UPDATE**.
>After some data manipulation and conditions I want to Update the record with
>new data...
>Is it faster do the UPDATE using the RowId or using the WHERE clause again!?
>
>TIA!!!
>
>Danny

It is faster to use the rowid. Think of it: even if you have the primary key in your where statement, you will use 3 or 4 LIOs. Using the rowid you have only one.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Mar 04 2004 - 23:28:55 CST