Domanda di colloquio di Hexaware Technologies

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