PCCW Interview Question

how to do SQL tuning when it loads to failure?