UBS interview question

Performance tuning techniques for poor performance queries