Yahoo interview question

How would optimize a SQL select query?