| Writing
Fast Queries |
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | EXPLAIN SELECT |
|||||||||||
| – | Tells you what MySQL is thinking |
|||||||||||
| – | Which keys (indexes) can it use |
|||||||||||
| – | Which keys will it use |
|||||||||||
| – | How many rows must it examine (roughly) |
|||||||||||
| • | ANALYZE TABLE
can help |
|||||||||||
| – | How hard must MySQL work? |
|||||||||||
| Copyright 2003, Jeremy Zawodny |