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?