Re: deterministic function

I don't need to do anything subtle.

Create a deterministic function to do a
simple 'return input' based on a number.

Create function based index using said
function, on a column where every single row has the same value.

Watch the session stats do one recursive call per row in the table. QED - the function is not taking advantage of being deterministic.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____Denver_______December 2/4
____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





FC wrote in message ...


>Well, I expect Oracle to cache the result(s) somewhere, I think you

should


>try with some sort of loop or sleep time taking seconds or even

minutes


>before returning the result, then, if it works as you say, the second

time


>you call the function with the same arguments, the response time

should be


>instantaneous.

>

>Bye,

>Flavio