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: Improving performance of calculations in PL/SQL

Re: Improving performance of calculations in PL/SQL

From: John Russell <netnews8_at_johnrussell.mailshell.com>
Date: Wed, 28 Jan 2004 06:13:49 GMT
Message-ID: <rdke1096viruus3gt3eq4qkp5rv262trbd@4ax.com> 





On 27 Jan 2004 02:06:37 -0800, charlie3101_at_hotmail.com (Charlie
Edwards) wrote:


>Thanks for those suggestions.  I've already done a lot of that, but I

>didn't know about the performance issue with using pls_integer for

>integer variable.




Also use INDEX BY PLS_INTEGER rather than INDEX BY BINARY_INTEGER.



John

--
Photo gallery: http://www.pbase.com/john_russell/


Received on Wed Jan 28 2004 - 00:13:49 CST












Original text of this message













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