Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news
Partners
Testimonials
Jonathan Fistley: "I appreciate all the dedicated help we've gotten from you and your staff. I'm a fan of your product and of your service oriented approach".
Aaron T. Judow: "SQL Maestro Group have created an exceptional tool for MySQL server maintenance and data reservation. I recommend it to all who need to operate efficiently".

More

Add your opinion

Service Center for MySQL online help

Prev  Table of Contents Next 

Analyzing tables


MySQL Service Center provides you with a feature that analyses and stores the key distribution for the tables. This feature is identical with running myisamchk -a for the table. If you wish to be able to perform this operation with your tables, you should create a new task specified as the analyze task in the Add Task Wizard. After the task is added, you can execute it explicitly or set its options to execute it by schedule.

Note: This feature works only for MyISAM and BDB tables.

See also:





Prev  Table of Contents Next