Microsoft interview question

How would you optimize a database query for faster performance?