Re: UPDATE takes so long - any suggestions

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: 2000/03/02
Message-ID: <Emjv4.4287$NO6.342860@bgtnsc06-news.ops.worldnet.att.net>#1/1

In SQL*Plus, enter:

SET AUTOTRACE ON EXPLAIN and then start your query and cancel it. That'll generate the plan Oracle optimizer decided on. That will tell you if it is using indexes.

Sally Madeira <softsense_at_home.com> wrote in message news:38BDAE7C.7360303E_at_home.com...
> 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 Thu Mar 02 2000 - 00:00:00 CST