What is filter factor?

Question Posted / guest

Answers were Sorted based on User's Feedback

What is filter factor?..

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

More DB2 Interview Questions

How to resolve -407 sql code in DB2?

How can you find out the # of rows updated after an update statement?

Can you access the DB2 Directory table using SQL?

What is dclgen (declaration generator)?

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

What is a view? Why use it?

What is the difference between cursor stability and repeatable read isolation levels?

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

When is the skeleton cursor table created?

List some fields from sqlca?

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

What is -904 sql code? How to resolve it?

For more DB2 Interview Questions Click Here