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

Home -> Community -> Usenet -> c.d.o.misc -> Re: trying to improve this process

Re: trying to improve this process

From: lou_nyc <lnlx_at_aol.com>
Date: 14 May 2006 21:25:02 -0700
Message-ID: <1147667102.689501.180160@v46g2000cwv.googlegroups.com>


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

Original text of this message

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