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 with ur in db2?
How would you find out the total number of rows in a db2 table?
can we view the access paths created by dbrm ? how ? thx
What types of tables are there in the db2 database?
What is check constraint in db2?
What type of database is db2?
What is explain in db2?
What is dbrm?
What is syscat in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is sqlca?
How do I add a column in db2?
What are bind parameters in db2?
What is db2 look?