What is filter factor?

Answer Posted / s

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do chiropractors use drop table?

669


Is ibm db2 open source?

592


Why do we bind in db2?

637


What are the contents of a dclmgen?

635


What is the physical storage length of timestamp data type?

646






Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

635


What is isolation level in db2?

585


Is the primary key a clustered index?

619


What is the clustering index in the db2 database?

590


what is utility for parm lib

1888


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

593


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

10791


What is with ur in db2?

770


What is sqlca’s maximum length?

681


Define db2.

676