Pergunta de entrevista da empresa UBS

Explain how you would optimize a SQL query that is running slowly on a large database. What steps would you take to diagnose and improve its performance?