Question d’entretien chez Infosys

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