Re: SELECT: How to re-use result of complicated function ?

"Romeo Olympia" <rolympia_at_hotmail.com> a écrit dans le message de news:42fc55dc.0408300650.765bfa39_at_posting.google.com...
> What kind of functions do you have? Do their results depend solely on
> the input parameters and not on any session variables or database
> objects which might change in between calls?
>
> If yes, then you could also try declaring your functions as
> DETERMINISTIC. If this is feasible, then Oracle does not re-execute
> the same function with the same parameters within the same statement.
>
> See the PL/SQL manual for details on this. HTH.

Using deterministic or not is not relevant for this case. The number of times the function is called is not dependant on this parameter. It depends only on the execution plan.

Have a look at this tread on Ask Tom's site: http://asktom.oracle.com/pls/ask/f?p=4950:8:3809045269958567894::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3575529924010,

-- 
Regards
Michel Cadot