My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What is reorg in DB2

3 Answers   Virtusa,

---

What is meant by union and union all?

0 Answers  

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

difference between group clause and order clause

1 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

What is DCLGEN ?

3 Answers  

---