Re: Dynamic Optimizer problems??

Posted in 1996

David Williams — Fri, 15 Nov 1996 16:18:52 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <328BAF1B.1805@erols.com>, "Ronald E. White" <ronwhite@erols.com> writes >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. > Have you tried running "UPDATATE STATISTICS". If this does not help then what it the SQL for the query? -- David Williams