Slalom Interview Question

How to improve performance of a long running query?