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
Which is faster delete or truncate?
What is null indicator in db2?
What is the clustering index in the db2 database?
What is runstats db2?
What is lock escalation in db2?
B37 abend during spufi?
How do I import data from excel to db2?
What is dbrm in db2 database?
What is cursor with hold option in db2?
What is catalog database in db2?
How many types of page locks can be held in db2?
What are the contents of a dclmgen?
Is db2 a mainframe database?
Is the primary key a clustered index?
What do you mean by commit and rollback?