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 filter factor?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is db2 catalog database?
What is meant by dclgen?
What is UNION,UNION ALL?
What do you need to do before you do EXPLAIN ?
Explain the function done by data manager?
Give the name of some fields form sqlca.
What is iseries database?
When do you specify the isolation level?
What is load replace in db2?
How do you filter out the rows retrieved from a Db2 table ?