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 -> Performance of User defined functions in Select stmts

Performance of User defined functions in Select stmts

From: <abacusnow_at_my-dejanews.com>
Date: Thu, 27 Aug 1998 14:46:21 GMT
Message-ID: <6s3rfu$d85$1@nnrp1.dejanews.com> 





I am in the process of replacing a multi layer DECODE statement with a call
to a function.	I will be running on Oracle 7.1.6 for a short time and the
statement will need to process up to 8 million records.



Using the decode method it currently takes 2 hours to run.  Should I leave
well alone?




-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum
Received on Thu Aug 27 1998 - 09:46:21 CDT












Original text of this message













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