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

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

How do I add a column to an existing table in db2?

What is a db2 cursor?

What is concurrency in db2?

How can you split a table in to exactly half?

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

How to execute stored procedure in db2 command editor?

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

What is cobol db2?

How do you find the maximum value in a column in db2?

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

How does the processing of a correlated subquery differ from a non correlated subquery?

For more DB2 Interview Questions Click Here