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 an asychronous write?
When DB2 connection fails, will online program work or give errors.
What do you do to keep the cursor from closing after a commit?
What is a db2 collection?
What is the error code -803 ?
How to rename a table in DB2 ?
What is a DB2 plan?
What is a data page?
Request to database but database is not available so what is was abend is raised?
What are the three lock types?
Define predicate?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)