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 |
Where would you find information about the type of database authority held by the user?
List out the buffer pools in db2
Why select is not preferred in embedded sql programs?
Highlight all the advantages that are attached to a package.
What is concurrency?
What is plan in cobol db2?
how can u nderstand the sql stmts executed successfully or not ?
Name the various locking levels available?
What is page size in db2?
What is db2 bind process?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?