Pergunta de entrevista da empresa Infosys

How do you do performance tuning against a long running SQL query