On Jan 9, 2008, at 12:00 AM, Anoo Sivadasan Pillai wrote:
>
>>> 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. But most likely this is just a one-time
>> problem.
>
> Is there any way to clear the cached plan manually other than
> disconnecting (With the help of some commands/Configuration
> settings) ?
Only as of 8.3.
Erik Jones
DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com