Date: 06/12/07 (Java Web)    Keywords: mysql, sql

ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query. ANALYZE helps query optimizer to make accurate decisions by detailed analysis of the data, unlike query optimizer which makes quick analysis. The command [...]

Source: http://blog.taragana.com/index.php/archive/how-to-quickly-analyze-all-tables-in-mysql-database/