Answer Posted / uday
According to what i have observed, cardinality is the number
of count of nodes in the BTree of respective index.
If you create a table with with name attribute and inserted
into 100 new names and added and index.
then if you see the cardinality, certainly it wont be 100.
it will be some thing less than 100.
thats it....
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is alias in db2?
what is the role of the cursor in db2?
Mention the various locks that are available in db2.
What is dclgen (declaration generator)?
What is universal database?
What are host variables in db2?
What is catalog database in db2?
What is a buffer in memory?
What are the contents of a dclmgen?
What db2 400?
Can one database have multiple instances?
Which are the db2 tools to protect integrity of the database?
What is explain plan in db2?
What is plan in cobol db2?
What is host variable in db2 cobol?