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 are PACKAGES ?
what is diffrence b/w file-aid tool and file-aid utility???
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is query_cache_limit?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is the use of db2?
List some fields from sqlca?
What is cursor?
What is a correlated sub query?