select 100 records from million records ?

2 Answers   Verizon,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

what is plan? is plan executable or package?

4 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

What is runstats and reorg in db2?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What db2 400?

0 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What is db2 catalog database?

0 Answers  

---