THE ICONIC interview question

How do you optimize a database query?