Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help on regular interview question

Priya1111Feb 12 2014 — edited Feb 13 2014

Hi all,

As a developer , what would be the answer for the following  interview question. How would you do performance tuning, on a query or a stored procedure.?

My regular answer is,

1. I would see the Explain plan

2. Index the predicate columns

3. use joins instead of subqueries where ever possible

4. use Hints

5. select only required columns, rather than select *

Can any one please help me , to answer for this question. I know this question is vague. But this is a regular question. I am really clueless .Neep Help

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2014
Added on Feb 12 2014
4 comments
2,923 views