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 an alias?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is a lock?
Mention the various locks that are available in db2.
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is correlated subquery?
What is a buffer in memory?
How to find the number of rows in db2 tables?
What is a db2 tablespace?
If I have a view which is a join of two or more tables, can this view be updateable?
How does a cursor work?
how do u update the faltfile into db2 table ?