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 check constraint. Explain with example.
define clustering index.
what are bind concepts in db2 cobol?
What is schema in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is a db2 tablespace?
What is bind and rebind in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Explain the benefits you can get from mainframe connect?
What is a system catalog table in db2?
Mention the various locks that are available in db2.
What is nvl in db2?
Explain in detail about buffer manager and its functionalities?
What is an instance in db2?
What is phantom read in db2?