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
> date.
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
--
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)
