What is filter factor?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is the difference between Where and Having Clause
What is correlation names?
What is a DB2 bind?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the syntax for creating a table in the db2 database?
Explain the function of data manager.
What is the physical storage length of timestamp data type?
How and when does the db2 enforces the unique key?
What is lock contention?
what is load and unload in db2
What is innodb buffer pool?
What is the function of buffer manager?