In article <6h8ihq$nu8$1@news.xmission.com>, Sujit.Pal@alltel.com writes
> In any case we found the EXPLAIN PLANs were clean in the SPs. We
> obtained some (around 10%) gains by moving SPL global variables into
> the local variables for SPLs. We are investigating the problem further
> and will let this group know if we uncover anything.
>
Any chance you could post and example stored procedure?
>
> Thanks for all your help.
>
> Sujit
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care