Domanda di colloquio di Everest Technologies

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