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
- 18116 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
how many ways we can we find the current date using mysql? : Sql dba
Why is a primary key important?
Where the sql database files are stored?
What is the difference between count 1 and count (*) in a sql query?
What is a common use of group by in sql?
What are the types of variable use in pl sql?
What is difference sql and mysql?
What is the purpose of design view?
How can we solve sql error: ora-00904: invalid identifier?
What is a function in oracle pl sql?
Why do we use triggers?
how to use 'mysql' to run sql statements? : Sql dba
Which command is used to delete a trigger?
How do you exit in sql?
Can we use pl sql in mysql?
