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
How to resolve deadlock issue
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is alias in db2?
what is db2 restart?
What types of tables are there in the db2 database?
Define predicate?
What is innodb buffer pool?
What is cursor with hold option in db2?
How can deadlocks be resolved?
Which isolation level provides highest data integrity?
Which component is responsible for db2 startup and shutdown?
How do I copy a table in db2?
What is the purpose of using commit?
How many types of page locks can be held in db2?
What is isolation level in db2?