Thanks for replying. I remember having to use those sort of tricks to get more performance out of mysql queries in the past.

I use postgres these days and my system characteristics are such that I don't have to worry about query performance so much. Though I have found that I've needed similar tactics sometimes with postgres too.