RE: How to do faster updates

From: <Rick_Cale_at_teamhealth.com>
Date: Fri, 13 Sep 2002 12:38:31 -0800
Message-ID: <F001.004CFDE6.20020913123831@fatcity.com>

Unfortuneatley that does not meet his requirements of "I want to update some thousand records based on a column which is not a part of any index."

                                                                                                                   
                    "Gogala,                                                                                       
                    Mladen"              To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <MGogala_at_oxhp.       cc:                                                                       
                    com>                 Subject:     RE: How to do faster updates                                 
                    Sent by:                                                                                       
                    root_at_fatcity.c                                                                                 
                    om                                                                                             
                                                                                                                   
                                                                                                                   
                    09/13/2002                                                                                     
                    03:23 PM                                                                                       
                    Please respond                                                                                 
                    to ORACLE-L

Truncate the table first, that will really speed the update up.

> -----Original Message-----
> From: Pillai, Rajesh [mailto:Rajesh.Pillai_at_nordstrom.com]
> Sent: Friday, September 13, 2002 1: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_at_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_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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rick_Cale_at_teamhealth.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 Fri Sep 13 2002 - 15:38:31 CDT