RE: Bad Distributions bug #91664
I have version 7.24.UC4. It is fixed in 7.24.UC5.
-----Original Message-----
From: ]Steve Berg [SMTP:spb@masada.nb.com]
Sent: Thursday, April 23, 1998 5:25 AM
To: Don Simpson
Cc: informix-list@iiug.org
Subject: Re: Bad Distributions bug #91664
What version of 7.24.xx where you running?
Steve Berg
spb@nb.com
On Wed, 22 Apr 1998, Don Simpson wrote:
> Heads up for all you running 7.24 and I believe 7.23 as well.
Not sure
> if all platforms or not.
> B91664:
> [REGRESSION IN BACKPORT OF FIX TO B80471. UPDATE STATISTICS
PRODUCES
> BAD ]
> [DATA DISTRIBUTIONS AFFECTING QUERY PERFORMANCE.
>
> I recently upgraded to 7.24 from 7.22 on Solaris 2.5.1.
Thanks to Bob
> Weiman, Informix Engineer, who visited my local IUG, I
learned of the
> bug before pulling my hair out trying to figure out why some
of my
> querries were so slow.
>
> This bug has an ill effect on the data distributions when
doing update
> statistics medium and high. The distributions are inaccurate
and
> incomplete. I was told that the only work-around without a
patch is to
> drop all distributions. That wasn't enought for me, I got the
patch.
> Everything is fine for me now. If you are running version
7.23 or 7.24
> you may want to check your distributions after doing medium or
high
> update statistics and make sure they look ok, and call supportif not.
>
> Don.
>
>
>