Re: SET EXPLAIN / SQL

On Mon, 14 Sep 1998 11:40:36 -0700 (PDT), Jonathan Leffler <jleffler@informix.com> wrote: >And, in version 7.2 and above, there is an extra option to the ESQL/C OPEN >statement: > >EXEC SQL OPEN c_select USING :var1, :var2, ... WITH REOPTIMIZATION; But this doesn't seem to be available neither in 4GL nor Dynamic 4GL? To me it would seem more than usefull in many cases. >That usually only makes sense if there are parameters to the statement; if >there are no parameters and there have been no changes in the statistics, >then the reoptimization simply wastes times and produces the same query >plan. > >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 Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)