Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Loader to update rows FAST - help!
Thanks Dave,
A full table scan takes about 30 seconds. Each row has about 10 NUMBER columns, nothing fancy.
My reasons for SQL*Loader were:
Thanks again,
Chris
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/
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Dec 13 2000 - 17:54:14 CST
![]() |
![]() |