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: Ed Prochak <edprochak_at_gmail.com>
Date: 14 May 2006 19:02:17 -0700
Message-ID: <1147658536.951968.36660@j55g2000cwa.googlegroups.com> 






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
Received on Sun May 14 2006 - 21:02:17 CDT












Original text of this message













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