Report question

Question: How to tune a 7-table-join MySQL count query where tables contain 30,000+ rows?