Re: Dynamic Optimizer problems??

Posted in 1996

"Billy Wheeler" — 15 Nov 1996 02:23:28 -0500 — source: Informix-list mailing list archive (1991-1998)

On 14 Nov 96 at 18:45, Ronald E. White wrote: > 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. That's almost funny. Anyway, sometimes you can maybe possibly kind of sort of fool the optimiser by having mutiple references to the little table to make it appear more important - if there is a part of the where clause which refers only to the little table, repeat that several times. YAMMOMNV. HTH. -- Ciao, Billy I'd be in favour of apathy, but I just can't get fired up about it...