Hexaware Technologies Interview Question

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