Slow execution when calling function from select - 05-25-2006 , 01:05 PM
I have a query that returns 1 row and runs in 1s.
select a,b,c,d from t1 where condition N
A B C D
Test 10 14 AB
I have a function that receives 2 parameters and executes in less than
select myFunc(14,'AB') from dual
When I combine the two together it takes over 30s to run.
select a,b,myFunc(c,d) from t1 where condition N
Any help would be appreciated.
Re: Slow execution when calling function from select - 05-25-2006 , 01:44 PM
And what happens to be that condition? And what happens
to be the query plan? And how many rows happen to be in
the table? In other words, give us a worked example.
Sorry, my crystal ball needs cleaning...
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)