Re: [Q] Which is Optimizer ?

Jonathan Leffler wrote: > On Tue, 8 Sep 1998, =C8=B2=BB=F3=B1=B8 wrote: > > I wonder which informix use optimizer mode. > > I know that Oracle use rule-base optimizing and cost-base optimzing. > > Informix also use cost and rule-base optimizer ? > > All current versions of Informix use a cost-based optimizer. Only the > older versions used a rule-based optimizer. And was that prior to version > 4 or prior to version 5? I think it was prior to version 4 -- antique. Prior to version 4. In other words, 2.10 Turbo and SE. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on Peanut M&M's