<- Previous
MySQL Server and Application Performance Tuning
2001 O'Reilly Open Source Convention
Jeremy D. Zawodny, Yahoo! Inc.
Next ->
Writing Fast Queries: Indexes
Index the fields used often in WHERE clauses
Understand how indexes work
Don't overuse them
Know when MySQL won't use them
Use
EXPLAIN
to see what it's thinking
Use a partial index on a large fields to save space
See:
http://www.mysql.com/doc/M/y/MySQL_indexes.html
<- Previous
San Diego, California
Wednesday, July 25th 2001
http://jeremy.zawodny.com/oscon-2001/mysql/
Next ->