Pergunta de entrevista da empresa Saviynt

How would you optimize a SQL query if it is running slowly after so may years of usage?