New to MySQL, need help/theory/application of indexes

Am new to MySQL. Can someone point me to where there is detailed information on the theory/practical application of indexes? Like starting from the third grade and working up from there?
Don’t mind buying a book if needed. Just looking for good/solid/useful information to help with an effort to master MySQL. Doing searches is fine but my experience is that you can’t beat a tip from someone who knows what’s going on. In addition as I’m teaching myself, I don’t want to wind up missing key pieces information so it would be great if there was comprehensive coverage some where or in a list of places.

Thanks

Ed

sitepoint has several articles on query optimization (i.e. judiciously applying indexes)

Wow! Mr. R.L. The man himself!

Have your book Simply SQL. Really great stuff and absolutely helpful. Am recommending it anyone who is trying to learn SQL as a beginner’s “must have” as in “No, really, get this book”. Rather why I’m here now. :slight_smile:

Tried searching for the referenced article. On site and google. Can’t find. A url?

well, whaddya know… i was sure sitepoint had articles… apparently, sitepoint no longer has articles

anyhow, thanks for the very kind words :slight_smile:

you cannot go wrong reading the results of a search on the entire phrase “mysql query optimization”

and, of course, there is always da manual, eh :wink: