Pergunta de entrevista da empresa Elsevier

We have a SQL query which runs for 4 days. How would you optimize it?