Infosys interview question

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