Hello David Define index on all fields in the where clause. Full table scan or reading a lot of records by index for each sql statement can cause this.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 6:24 PM > Hi all, > > I write a script to update 10,000 records in my database and noticed it took > more than an hour to update 10,000 records. The script just includes 10,000 > SQL update commands as shown below. Is the time too long to update 10,000 > records? Is it a way to improve the update task to run faster. Please > advise. > > *** A portion of my update script is shown below: > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = > 201 and lata_id = 224; > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = > 201 and lata_id = 224; > > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
