What is filter factor?

Answers were Sorted based on User's Feedback



What is filter factor?..

Answer / s

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

Is This Answer Correct ?    12 Yes 0 No

What is filter factor?..

Answer / deepak dada

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

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More DB2 Interview Questions

what is parm utility

2 Answers   IBM,


What is runstats and reorg in db2?

0 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  






What is precompiler in db2?

0 Answers  


what is Static and dynamic linking

1 Answers   Virtusa,


What is concurrency in db2?

1 Answers  


What is the role of data manager in the db2 database?

0 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


What is the difference between db2 and oracle?

0 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  


Categories