Question d’entretien chez Genpact

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