Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Loader to update rows FAST - help!

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

From: Luggy <dgh_consulting_at_my-deja.com>
Date: Wed, 13 Dec 2000 13:31:52 GMT
Message-ID: <917to9$gbf$1@nnrp1.deja.com>

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/ Received on Wed Dec 13 2000 - 07:31:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US