What is filter factor?
Answers were Sorted based on User's Feedback
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 |
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 |
what is parm utility
What is runstats and reorg in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is precompiler in db2?
what is Static and dynamic linking
What is concurrency in db2?
What is the role of data manager in the db2 database?
where can we use index and subscript ? with example ?
What is the difference between db2 and oracle?
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?