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 does one remove entries from the SCT02 table?

1 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

Can you Average the Characters ?

3 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What do you mean by storage group (stogroup)?

0 Answers  

---

When will you chose to run RUNSTATS?

1 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What is temporal table in db2?

0 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

What are the different types of base tables?

0 Answers  

---