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 |
Explain in detail about buffer manager and its functionalities?
What are foreign keys?
Explain packages.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the use of value function?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Explain about dbrm.
can you use symbolic parameters in JOB?
What are union and union all?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What does it mean if the null indicator has -1, 0, -2?