What is filter factor?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1245


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10791


How would the varchar column remarks defined?

643


Which command is used to connect to a database in DB2 ? Give the Syntax.

609


What is meant by union and union all?

595






What are packages in db2?

601


What is scrollable cursor in db2?

592


Mention data types used in db2 ?

688


What is db2 catalog database?

589


Explain about rct.

656


What is ibm db2 database?

543


What is explain in db2?

587


What is blu acceleration in db2?

612


What is the physical storage length of date data type?

735


What is the difference between nvl and coalesce?

608