Answer Posted / sudipta santra

First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.

There are so many logic for make a query tune.

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2319

---

What is SQL Tuning Advisor in Oracle?

1106

---

How to change user password in oracle?

974

---

Can sub procedure/function be called recursively?

946

---

What is backup in Oracle?

950

---

Difference between cartesian join and cross join?

956

---

What is a table index in oracle?

1067

---

How do I uninstall oracle 11g?

1041

---

Explain the different normalization forms?

1009

---

What are the tools for Oracle ?

1007

---

What is a initialization parameter file in oracle?

987

---

What is oracle database client?

974

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3813

---

Explain cascading triggers.

1012

---

Explain how are indexes update?

1014

---