EMIS Group interview question

Performance Tuning in SQL