EXPLAIN is the way to go to check for performance improvements and optimization is mostly dependent on the schema design in the beginning consisting of of adding correct accurate indexes keeping a track of the space requirements for the index as well.