Valcon interview question

How would you optimize an SQL query in an azure environment?