Clark - 1:08 pm on Jun 2, 2003 (gmt 0)

No, in that case you only need one column index and it will be better to only use that one.

Depending on the complexity of what you build, the amount of tuning you can do is endless. Tune your php code, your selects, optimize your my.cnf file, your php file, your indexes. Your database layout. In fact, I was recently working like crazy trying to figure out how to get the data to look the way I wanted it to, then realized that by doing a major change in the way the database looked, mysql would automatically make the data look the way I wanted it to automagically without doing any queries.

If there is anything that is important in tuning up any database, it is understanding normalization really really well and when to apply it.