THE ICONIC Interview Question

How do you optimize a database query?