Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trying to improve this process
Ed Prochak wrote:
> lou_nyc wrote:
> > I have this proc....it is taking wayyy too much time....I am trying to
> > cut it the
> > amount of time.. any suggestions...
> >
> > PROCEDURE chassis
> > IS
> > CURSOR his_CUR IS
> > select i.chassis
>
> []
> > from inv_chassis_at_tripoli i
> > ,chassis_masters_at_tripoli chm
> > ,ssl_at_tripoli s
> > ,accounts_at_tripoli a
>
> remote links can slow things down.
> Sybrand's advice is good too.
>
> ED
cant remove the db links.... Received on Sun May 14 2006 - 23:25:02 CDT
![]() |
![]() |