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

Home -> Community -> Usenet -> c.d.o.server -> Re: Possible Tune-up?

Re: Possible Tune-up?

From: Guitarator <d.jeanneret_at_wanadoo.fr>
Date: 26 Jul 2006 23:39:35 -0700
Message-ID: <1153982375.323594.69060@m79g2000cwm.googlegroups.com> 





Hi



Hum, first at all



    
  
  1.   move the "SELECT COUNT (*) INTO v_count1
           FROM msf221 "
before the main cursor loop.

  
  2.   Try to updating by mixing the cursor and the update order if
possible.






regards


Denis
Received on Thu Jul 27 2006 - 01:39:35 CDT












Original text of this message













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