Amdocs interview question

How to tackle long running queries? How to check execution plan?