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

What is the use of predicate?

580


Explain the function of data manager.

632


What is netezza database?

570


What is database manager in db2?

549


What do you mean by rollback?

570






My sql statement select avg(salary) from emp yields inaccurate results. Why?

638


List out the buffer pools in db2

624


What are the contents of dclgen?

652


What is scrollable cursor in db2?

579


What is role in db2?

612


What parameters are used to control the free space in DB2?

640


How do I delete a table in database?

595


What is runstats db2?

576


What is db2 bind?

636


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

628