What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 16972 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 are sql functions? Describe the different types of sql functions?
what are sequences
What is multiple columns?
what is a table in a database ? : Sql dba
What is column?
Can function return multiple values in sql?
Why trigger is used in sql?
What is use of package in pl sql?
What is your daily office routine?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What do you mean by stored procedures?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
what are the advantages of mysql in comparison to oracle? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
