EXL Service Interview Question

How to optimize slow running query?