Answer / s

RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.

What is the physical storage length of timestamp data type?

0 Answers  

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

what is the Foreign key? explain?

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

What is a clustering index ?

3 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

What is buffer pool and list some of them?

0 Answers  

---