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

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

What is db2 catalog database?

What is cascading rollback?

wht displays the number of times a query modified ?

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

What is reorg?

What's The Error Code For Unique Index Voilation?

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

What is package in cobol db2?

is there any restrictions for unions ?

What is dclgen in db2?

how to resolve -811 sqlcode .give clear explaination

For more DB2 Interview Questions Click Here