Re: Dynamic Optimizer problems??
Posted in 1996
Topics: Performance & Tuning
We too have had problems with optimizer ... (not enough time to type all details, email me if you're really interested) ... try setting OPTCOMPIND=0 .. this did the trick for us when I had similar problem. -Lin Ronald E. White (ronwhite@erols.com) wrote: : Has anyone had any problems with Informix's dynamic optimizer? We're : running Informix with PeopleSoft and seem to be having problems with the : dynamic optimizer going to the BIG table to do its first search, then : going to the little table last. When on those rare occassions it goes to : the little table first and then to the BIG table the job completes in 5 : to 10 minutes. Otherwise it takes several hours. : Informix seems to think that their product doesn't have a problem, and : that we can correct the situation by making the little table REALLY BIG : by putting in a lot of dummy records. : -- : Ron White : ronwhite@erols.com : "...he who ceases to learn is already a half-dead man." : -- Zachary Verne in Louis L'Amour's "The Lonesome Gods"