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

What are PACKAGES ?

what is diffrence b/w file-aid tool and file-aid utility???

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

What is query_cache_limit?

Is it mandatory to use DCLGEN? If not, why would you use it at all?

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

What is the use of db2?

List some fields from sqlca?

What is cursor?

What is a correlated sub query?

For more DB2 Interview Questions Click Here