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

Mention the downsides of page level lock.

0 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

What are the four lockable units for DB2?

1 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

How to resolve deadlock issue

5 Answers   IBM,

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

What is buffer pool in the db2 database?

0 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---