| 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
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |