RiskLogic interview question

If a certain query is having performance issue, how would you tackle this problem?