I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

What is EXPLAIN?

1 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

Define declaration generator (dclgen).

0 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

why we create view.

5 Answers  

---

What are the various locks available?

5 Answers   CTS,

---

Can we update view in db2?

0 Answers  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---