Pergunta de entrevista da empresa Hexaware Technologies

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