Domanda di colloquio di Genpact

How would you optimize a slow-running SQL query in MySQL?