Ambush interview question

How would you optimize a database query?