RE: 407: Error number zero received from the sqlexec process.

Posted in 2003

Murray Wood — Wed, 28 May 2003 10:57:27 +1200 — source: Usenet: comp.databases.informix

Yes it does. We had an sql using SE 7.23 which always chose the wrong path to return an sql. One of the columns in the where clause had very skewed data (> 90% had one value). We had run update stats medium on all tables. Running update stats high on that table changed the optimiser selection to the correct method for that sql. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Jonathan Leffler > Sent: Tuesday, 27 May 2003 6:03 p.m. > To: informix-list@iiug.org > Subject: Re: 407: Error number zero received from the sqlexec process. > > [cut] > > I'm not sure that SE pays much attention to statistics low, medium, > high, etc -- I thought none, but I'm open to correction on it. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ >