RE: Whatcha' wanta have?????

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 sending to informix-list