Pergunta de entrevista da empresa Zywave

How would you optimize [insert some database query]? How would you be able to profile its performance?