Check out this great article that does a good job of explaining the use of indexes to optimize queries. Also a good explanation of EXPLAIN, OPTIMIZE, ANALYZE and TRUNCATE.
Posted on 08 December 2001 by Demian Turner
Check out this great article that does a good job of explaining the use of indexes to optimize queries. Also a good explanation of EXPLAIN, OPTIMIZE, ANALYZE and TRUNCATE.