Microsoft Interview Question

How would you optimize a database query for faster performance?