Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 18091 Views
- Cap Gemini, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / dinesh kumar
Step 1: Use 3rd Normal form in Database design and create
Indexes in the table.
Step 2: Use Hints in the Query.
Step 3: Use Explain Plan and check for the cost
Step 4: Rewrite the Query to tune as per the Explain plan.
Step 5: Avoid Function based Indexes.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Define sql delete statement.
Define overloaded procedure?
what are different types of collation sensitivity? : Sql dba
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Differentiate between pl/sql and sql?
Difference between global and parameter variables?
What is sqlerrd?
What is difference between inner join and self join?
How do you explain an index?
What are some emotional triggers?
What are the 3 types of behavioral triggers?
Why is stored procedure faster than query?
What is sql*plus?
Can %notfound return null after a fetch?
What type of join is sql join?
