Pergunta de entrevista da empresa Siemens

How would you optimize a slow query that is causing a bottleneck in a critical service?