Facile.it Interview Question

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