Microsoft interview question

How would you optimize an SQL query?