Jonathan,

We 'set optimization low' in a sessions that
run stored procedures.

Procedures themselves do not contain 'set optimization low',
neither sessions from which procedures were created:
we really need maximized SQL plan, we just do not
want procedures to be reoptimized 'on the fly'

My understanding (from my previous experience and from
Informix documentation), is that SPL reoptomization is
controlled by 'optimizer' setting of a session that executes
the stored procedure. Am I wrong?

It looks like, any 'heavy' alter table (index creation,
constraint creation) of our 'online' tables immediately
causes -710 on all transactional clients. These clients ONLY
access the database through SPL.

Clients are written in C++ using Informix Object Interface libraries

------------------------------------------
Alexey Sonkin
Senior Database Administrator

> -----Original Message-----
> From: jleffler@us.ibm.com [mailto:jleffler@us.ibm.com]
> Sent: Wednesday, February 11, 2004 1:53 PM
> To: informix-list@iiug.org
> Subject: Re: Whatcha' wanta have?????
>
> mosserp@wellsfargo.com wrote:
> > Related: Implement outstanding feature request to run "set optimization
> low"
> > from the *server* side.
>
> Can you elucidate this, possibly with the feature request (bug)
> number? Are you saying that you cannot run SET OPTIMIZATION LOW in a
> stored procedure? The request has to be processed by the server, so
> I'm confused...
>
> -=JL=-
sending to informix-list