Re: Using SQL*Loader to update rows FAST - help!

I doubt if you will be able to do 2M updates in 5 minutes. More like 15- 30, and closer to 30, if you have a finely tuned real hog of a server (mainframe OS390, IBM S80, HP V-class, etc.).

I think you are going to have limited options. Either PL/SQL reading the input file and doing the updates or the OS 'native' language (C everywhere bu OS390, then COBOL?).

Make sure you have enough db block buffers (to save disk io).

In article <917to9$gbf$1_at_nnrp1.deja.com>,   Luggy <dgh_consulting_at_my-deja.com> wrote:
> Chris,
>
> SQL*Loader seems like a strange way to do it. Presumably this table
> with 4 million rows is in the database already? How long does it take
> to do a full table scan on the table? You can check this by going into
> SQL*Plus, typing "set timing on", then "select count(1) from
 <table>;".
> If doing the table scan takes longer than you need the update to run
> in, you may well be knackered, I'm afraid.
>
> How big is the column that you need to update, and how big is the
 total
> average row length on the table? Is the column to be updated indexed,
> and if so what kind of index is on it? All these things will have to
 be
> taken into consideration.
>
> Dave.
>
> Sent via Deja.com
> http://www.deja.com/
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com
http://www.deja.com/