List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:June 11 2002 11:47am
Subject:Re: MySQL AB: Need documentation clarification
View as plain text  
Erv,


----- Original Message -----
From: "Erv Young" <res04ft9@stripped>
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 leaves the user of InnoDB
> tables in limbo.  If this doesn't work on InnoDB tables, what takes its
> place, or why does its place not need to be taken?

both InnoDB and MyISAM keep also dynamically statistics about tables. In
most cases running ANALYZE TABLE does not bring any benefit in query
optimization.

> Thanks.
>
> --Erv Young

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com



Thread
MySQL AB: Need documentation clarificationErv Young11 Jun
  • Re: MySQL AB: Need documentation clarificationDan Nelson11 Jun
    • RE: MySQL AB: Need documentation clarificationJon Frisby11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationJeff Kilbride12 Jun
  • Re: MySQL AB: Need documentation clarificationJeremy Zawodny1 Jul