Pregunta de entrevista de Everest Technologies

How would you optimize an SQL query that is not performing well?