Oracle interview question

Solving SQl performance issues