Recently I have attend a Interview from MNC..

they asked that "How you deal with performance issues in Pl/Sql block"...

I said, Using Explan plan, we can know the full table scan area and we can put index whereever necessary ..like that
(for individual block of statement we have to check...)

Is there any systamatic way of approach to find the delay area of our Pl/Sql block of statement ???

Pl. Help