Facile.it interview question

How do you solve the issue of a slow (My)SQL query?