UBS Interview Question

Performance tuning techniques for poor performance queries