Pregunta de entrevista de Zywave

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