Answer Posted / 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 |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is scrollable cursor in db2?
Is it possible using max on a char column?
Why do we use cursor?
Which command is used to remove all rows from a table?
What is check constraint. Explain with example.
What is cloudant database?
How can record locking be achieved in those DB2 versions which do not support it?
How to restart a DB2 program?
What is runstats db2?
What is the use of db2?
List out the three types of page locks that can be held.
Is db2 a programming language?
What does reorg do in db2?
How is the value function used?