On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote:
> > both InnoDB and MyISAM keep also dynamically statistics about tables. In
> > most cases running ANALYZE TABLE does not bring any benefit in query
> > optimization.
> Personally, I'm pretty shocked to hear you say this. I was under the
> impression that running ANALYZE TABLE was a "good thing" and helped
> ensure the key distribution for the table in question was up to
You're correct. There are times when the MyISAM table handler looses
touch with what the table really contains. Running ANALYZE or
OPTIMIZE will fix that.
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.51: up 32 days, processed 706,777,053 queries (248/sec. avg)