Oninit cdi / Archive
Talk to an expert →

OPTCOMPIND

Posted in 2003

Topics: General Discussion

↪ replying to bil
Neil Truby — — source: Usenet: comp.databases.informix

Not exactly, but it is possible to override the engine value for each user by setting the appropriate environment variable. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "bil" <bil.gates@microsoft.com> wrote in message news:bjsf7s$mcfi2$1@ID-82794.news.uni-berlin.de... > some of my jobs are very faster with OPTCOMPIND at 0 and others are faster > with OPTCOMPIND at 2. > > is it possible to dynamically change this value ??? > >

bil — — source: Usenet: comp.databases.informix

some of my jobs are very faster with OPTCOMPIND at 0 and others are faster with OPTCOMPIND at 2. is it possible to dynamically change this value ???

↪ replying to bil
Gorazd Hribar Rajteri��� — — source: Usenet: comp.databases.informix

You can use optimizer directives. Since I don't know, what your jobs are doing, I can't really tell which directives apply to your case. You can look at chapter 3 at http://www.klimaexpert.com/gorazd/informix/index.html Gorazd "bil" <bil.gates@microsoft.com> wrote in message news:bjsf7s$mcfi2$1@ID-82794.news.uni-berlin.de... > some of my jobs are very faster with OPTCOMPIND at 0 and others are faster > with OPTCOMPIND at 2. > > is it possible to dynamically change this value ??? > >

Related threads