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

Home -> Community -> Usenet -> c.d.o.tools -> UPDATE takes so long - any suggestions

UPDATE takes so long - any suggestions

From: Sally Madeira <softsense_at_home.com>
Date: 2000/03/01
Message-ID: <38BDAE7C.7360303E@home.com>#1/1 






I have a simple query - I think it is to update the officenumber in a
table.  It is in the following format:



UPDATE Table1


SET OfficeNum = (SELECT Officenum

		FROM Table2
		WHERE cliNum = table1.clinum)





Not a problem but it take 20 minutes to update 50,000 records when i
believe it should only a few minutes.....



I have my indexes I believe set correctly.  Any suggestions on how to
increase the speed of this query.  How could I do a mass update....



Any suggestions would be helpful



S
Received on Wed Mar 01 2000 - 00:00:00 CST












Original text of this message













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