Answer / s

Yes denormalization is done performance reasons.
Normalization will keep the related data in separate
tables. In order to get the data from the tables, DB2 uses
JOIN which could be resource intensive depending on the
number of tables used in the join and the size of the table.

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

how will you retrieve first record in table

1 Answers   UST,

---

What is dbrm in db2 database?

0 Answers  

---

---

What is dpf in db2?

0 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,

---

What is meant by the attachment facility?

3 Answers  

---

What is explain in db2?

0 Answers  

---

What does runstats do in db2?

0 Answers  

---

What is iseries database?

0 Answers  

---