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 |
Is it possible using max on a char column?
What is table space in db2?
When is the access path determined for dynamic SQL?
how can we retrieve the 100 records of the file ?
Explain the function of data manager.
What is the maximum size of varchar data type in db2?
Define sqlca.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
wht steps we need will coding cobol and db2 pgm ?
What os does db2 run on?
What is dpf in db2?
Mention the location where the output received from explain statement is stored.