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

Explain about dbrm.

607


What are the benefits of using the db2 database?

658


What is blu acceleration in db2?

603


How to check last update on table in db2?

626


What is dclgen in db2?

676






What action db2 takes when a program aborts in the middle of a transaction?

657


What is bind package and plan in db2?

591


What is the role of data manager in the db2 database?

642


What is a db2 cursor?

622


What is an instance database?

598


How can deadlocks be resolved?

540


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

606


When reorg is used?

670


What does sqlcabc has?

629


What is buffer pool?

607