eharetea

Use the EXPLAIN, ANALYZE, and SHOW statements to optimize queries.

Optimization!

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 01:16 AM

these tools will help in optimization:

SHOW TABLE STATUS;
SHOW TABLE STATUS \G;     /* the \G helps the print look better */

EXPLAIN query;            /* examines a query and gives report  */

ANALYZE