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

Home -> Community -> Mailing Lists -> Oracle-L -> Function slows the select

Function slows the select

From: Csillag Zsolt <starsoft_at_interware.hu>
Date: Wed, 27 Jun 2001 03:08:59 -0700
Message-ID: <F001.00339A73.20010627032027@fatcity.com>


Hi,

In the following select statement I have a function "GetSid" that slows the
update for hours even if the Link_keszit updatable table consists of a few rows.

 Update 

UpdateTable--Varosokat
updatel
   Set UpdateTable_Column1=

                                                     

--

      (
        Select
distinct  'Some string here'||GetSid||UpdateTable_Column2||Logo.Logo_Filenev
        
         From VarosTorzs,Logo, Link_keszit
        
         Where
          logo_varos_unique_az  = link_keszit_varos_az
         
          and logo.logo_azonosito1= 'KKEPX' and logo.logo_azonosito2= '20200'
         
          and logo_varos_unique_az  = varos_unique_azonosito
      
           )
        
     Where UpdateTable_Column2 Is Not Null ;
The GetSid function is: CREATE OR REPLACE Function GetSid Return VarChar2 AS
 BEGIN
   return(SYS_GUID());
 END GetSid;
So the problem is that _with_ GetSid function it takes many hours instead of a few minutes. Thank you in advance Zsolt Csillag, Hungary
Received on Wed Jun 27 2001 - 05:08:59 CDT

Original text of this message

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