-
PL/Sql Performance Tunning - Interview Question
Hi,
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
--Sathy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|