Answer Posted / s
Cardinality is the number of distinct values for a given
column or group of columns.
FIRSTKEYCARDF contains the cardinality of the leading
column in the index
FULLKEYCARDF contains the cardinality of all the columns in
the index
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to access db2 tables in mainframe?
Is db2 a programming language?
What is dbrm in db2 database?
What is dbrm? When it will be created?
What is the use of dclgen in db2?
How do we specify index to include or not during bind process.
What is difference between alias and synonym in db2?
What is db2 stogroup?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain the contention situations caused by locks?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is temporal table in db2?
What is the maximum length of sqlca?
Is ibm db2 free?