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

From: Ron <support_at_dbainfopower.com>
Date: Thu, 4 Mar 2004 21:00:09 -0800
Message-ID: <uNGdnc_k7P8wmtXdRVn-jA@comcast.com>

Hello Daniel,

Access by rowid is the fastest access path.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Daniel" <danny.icha_at_usa.net> wrote in message news:96eef697.0403041432.2047d6c9_at_posting.google.com...
> 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
Received on Thu Mar 04 2004 - 23:00:09 CST