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
Is db2 a database?
List some fields from sqlca?
Mention the location where the output received from explain statement is stored.
Explain how can you do the explain of a dynamic sql statement?
What is difference between isnull and coalesce?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What language is db2 written in?
What is isolation level in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is temporal table in db2?
How to access db2 tables in mainframe?
List out the buffer pools in db2
define clustering index.
Is db2 free?
How can we retrieve the total number of records in RPG & CLLE?