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);

Explain the working of primary key?

0 Answers  

---

What type of database is sql?

0 Answers  

---

What is a .db file?

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

What does pl sql stand for?

0 Answers  

---

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

Explain the difference between triggers and constraints?

0 Answers  

---

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

What is trigger explain with example?

0 Answers  

---

Explain the difference between sql and mysql.

0 Answers  

---

is mysql query is case sensitive? : Sql dba

0 Answers  

---