Re: [Q] Which is Optimizer ?

Posted in 1998

Jonathan Leffler — Tue, 8 Sep 1998 12:08:56 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

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. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn