Tutorials on indexes?

[padders]

I am looking for a tutorial on indexes, when they should be used and when they should not be. If there are any costs associated with having them etc... any suggestions? my php books have very little on them ..

on this subject is there a decent mysql book out there that is realtivly readable (not database techno garble) and perhaps even written from a php coding point in mind? any suggestions?

[qslack]

These should help:

http://www.mysql.com/doc/M/y/MySQL_indexes.html
http://phpbuilder.net/forum/read.php...=0&thread=6085
http://www.forwiss.uni-passau.de/cgi-bin/info2html?(mysql.info)MySQL%20indexes

There isn't any special PHP interface to mySQL indexes, so the basic mySQL docs will be of most help to you.

[Ed Sullivan]

Ironically, I recently submitted an article on indexes in MySQL to SitePoint. Look for it soon!

As always, I have to recommend Paul DuBois' book "MySQL". The index/optimization portion isn't huge, but it covers more than my article. A lot of index knowledge just comes from experience, IMO.

[padders]

think i might have to get that then, if you recommend it got to be worth it.

[Philip Olson]

Best Practices: Database Indexing
-----------------------------------------------
http://phpbuilder.com/columns/tim20010110.php3