Answer / s

Filter Factor is the percentage of rows that qualify for a
coded predicate. It determines if an index will be used.

Answer / deepak dada

filter factor is a reciprocal of cardinality factor
and cardinality factor is no of distinct rec in particular
col

i want to delete 20th million record how ?

4 Answers   IBM,

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

What is a root page?

1 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What is node in db2?

0 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

What is a dbrm in db2?

0 Answers  

---

What is the difference between oracle and db2?

0 Answers  

---