What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 16104 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
what is the use of double ampersand (&&) in sql queries?
How to rename a column in the output of sql query?
What are literals in sql server?
Are stored procedures faster than queries?
Is postgresql a nosql database?
How many types of privileges are available in sql?
explain advantages of myisam over innodb? : Sql dba
Describe types of sql statements?
What is indexes?
Does sql between include endpoints?
write an sql query to find names of employee start with 'a'? : Sql dba
What is the difference between truncate and drop statements?
Is sql a oracle?
What is parallel hint?
What is pl sql block in dbms?
