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
- 17888 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 normalization in sql?
What is autocommit sql?
What is composite primary key in sql?
What is delimiter in pl sql?
What is consistency?
What is auto increment?
What are the types of functions in sql?
Is time a data type in sql?
What is materialized view. What are different methods of refresh?
What is Collation Sensitivity ? What are the various type ?
What is java sql drivermanager?
What are the different types of a subquery?
What are packages in pl sql and also explain its advantages?
Why we use stored procedure instead of query?
What are dml commands?
