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 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




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to