Answer / 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.

Answer / mathivanan

1.Create indexes
2.keep up to date statistics on tablese
3.Analyse execution plans using trace utilities
4.Make use of Bulk collect,For all,returning bulk collect into.
5.Use hints when necessary
6.Minimize datatype conversions
7.use PLS_INTEGER or BINARY_INTEGER for integer Arithmetic,use BINARY_FLOAT and BINARY_DOUBLE for floating-point arithmetic
8.pin frequently used packages in shared pool memory

Answer / varadarajsha

Using DBMS_PROFILER Package and API

Answer / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

What is an example of translating a date into julian format?

0 Answers  

---

What are different functions in sql?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

---

What is sql and db2?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

---

What is a join?

0 Answers  

---

What is data manipulation language?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---