Oracle Interview Question

Solving SQl performance issues