Question d’entretien chez Hexaware Technologies

How would you optimize a SQL query that is taking too long to execute?