RE: How to do faster updates

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Sat, 14 Sep 2002 02:23:19 -0800
Message-ID: <F001.004D0238.20020914022319@fatcity.com>

My opinion,
The column being updated need not have an index. If you could use an existing index for your update nothing like it.
if not,
If this is an adhoc request, you may use bulk collect in PL/SQL in off peak hours.
If this is a regular thing, then consider using index!

rgds
amar
http://amzone.netfirms.com

-----Original Message-----
From: Pillai, Rajesh [mailto:Rajesh.Pillai@nordstrom.com]
Sent: Friday, September 13, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L
Subject: How to do faster updates

Hi All,
I've a table of 10 M records and I want to update some thousand records based on a column which is not a part of any index. Please suggest the quickest way to do this.

Thanks,
Rajesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pillai, Rajesh
INET: Rajesh.Pillai@nordstrom.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Amar Kumar Padhi
  INET: TS2017_at_emirates.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Sep 14 2002 - 05:23:19 CDT