Infosys Interview Question

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