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

How can we read records for specific member in CL? AND rpg?

229


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

640


What is the use of db2 optimizer?

607


What is syscat in db2?

574


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044






How can we retrieve the total number of records in RPG & CLLE?

194


What does db2 mean?

581


What is blu acceleration in db2?

603


What is the physical storage length of time data type?

673


What is node in db2?

607


What is database manager in db2?

549


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2274


Give a brief description of db2 isolation levels?

599


Mention the different locking levels that are available in db2.

643


Which isolation level provides maximum concurrency?

662