Daily Archives: April 1, 2008

Use EXPLAIN to show which indexes are being used. mysql> EXPLAIN SELECT mycolumns FROM table1 LEFT JOIN table2;\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: ag type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1010 … Continue reading →