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

What is a predicate?

1 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

What is the max length of sqlca?

1 Answers  

---

What is db2 purescale?

1 Answers  

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is the advantage in De-normalizing tables in DB2?

1 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

What is the logical entity between plan and Package?

5 Answers  

---

What is cursor?

2 Answers  

---