Answer / sravani

when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)

How many clustering indexes can be defined for a table?

2 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is the role of data manager in the db2 database?

0 Answers  

---

define clustering index.

0 Answers  

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What are foreign keys?

1 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---