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 und
> 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 helpe
For the mail filter: SQL database
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 2:47 PM
Subject: Re: MySQL AB: Need documentation clarification
> Erv,
>
>
> - Original Message
Erv,
- Original Message -
From: "Erv Young" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, June 11, 2002 3:49 AM
Subject: MySQL AB: Need documentation clarification
> 2) Also, the discussion of ANALYZE TABLE at
> http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html lea
> Indexes are only used if they significantly reduce the number of reads
> required vs a full table scan (I believe 30% is mysql's threshhold).
> An IS NOT NULL clause may very well use an index if almost all of the
> records have NULL in that particular field. A != clause is a bit
> harder, sinc
In the last episode (Jun 10), Erv Young said:
> MySQL AB staff:
And the thousands and thousands of regular people reading this list :)
> 1) The recent discussion on the subject "Not using indexes???"
> brought to light an opportunity for interpreting the documentation in
> contradictory ways.
