Yahoo Interview Question

How would optimize a SQL select query?