Hexaware Technologies interview question

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