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