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 |
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
How do I add a column to an existing table in db2?
What is a db2 cursor?
What is concurrency in db2?
How can you split a table in to exactly half?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to execute stored procedure in db2 command editor?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What is cobol db2?
How do you find the maximum value in a column in db2?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
How does the processing of a correlated subquery differ from a non correlated subquery?