Re: Updating info

Also probably not without being able to consider the table structures, especially including the indexes on the two tables. You could also be getting into nasty things like disk i/o issues (are both tables on the same disk along with the indexes, other active tables and the other Oracle files?) In other words this is a tuning question and tuning something like this can sometimes be resolved in minutes, but sometimes only over the course of days. So we would need much more information. Sorry!

Rich Mycroft, Oracle, Sybase & SQL Server DBA.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:960995303.21239.0.pluto.d4ee154e_at_news.demon.nl...
> Not without the actual code.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Deborah Carter" <dcarter_at_cnfei.com> wrote in message
> news:ckL15.3249$L4.4638577_at_firenze.visi.net...
> > I am trying to increase the speed of a procedure that updates
 information
 in
> > a very large table according to changes made to a smaller table. The
> > procedure is taking almost half an hour. I've tested the select
 statements
> > in the cursors I'm using and that portion seems to only take 1 1/2
 minutes.
> > I believe the consumption of time is in checking the data before
 updating
> > and the update itself. Does anyone have any suggestions on how to make
 this
> > part faster. All help is appreciated. Thanks.
> >
> > Deborah Carter
> > Developer
> >
> >
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT