Step 1: Use 3rd Normal form in Database design and create Indexes

What are the steps you take to tune(performance tuning) the code in plsql?

Question Posted / dinesh kumar

4 Answers
18254 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

Please Help Members By Posting Answers For Below Questions

Why do we need a foreign key?

1162

how to include numeric values in sql statements? : Sql dba

1141

what is unique key constraint? : Sql dba

1092

What is oracle sql developer?

1113

What is an implicit commit?

1096

What is crud sql?

1025

What is pl sql in dbms?

987

What is online transaction processing (oltp)?

1057

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

explain advantages of innodb over myisam. : Sql dba

1174

What is 19 null in sql?

1015

What schema means?

937

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1219

Does truncate require commit?

1026

What is a behavioral trigger?

1019