Hi All,
I have a procedure which contains only one Select statement. The
procedure take more time than expected to complete, the select statement
inside the procedure was taking about 2 minutes to complete.
After running a Vacuum Analyze on the underlying tables the select
statement could
>> Why the procedure is not getting the performance advantage of Vacuum
>> analyse?
>Plan caching by the function, probably. Try disconnecting the session
>and reconnecting to prove the hypothesis.
>If it is a recurring problem for you, you could put the SELECT under
>EXECUTE in the function.
