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
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is runstats db2?
How can you count the number of rows from a table tab?
What are the full forms of spufi and dclgen and why are they used?
Mention the different locking levels that are available in db2.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the use of runstats in db2?
How do I connect my db2 database to ibm?
Describe major components of db2?
What is query_cache_limit?
Highlight all the advantages that are attached to a package.
What is innodb buffer pool?
How can you classify the locks in db2?
What are union and union all?