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!
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