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