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 the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the max length of sqlca?
What is the difference between plan and package in db2?
Why do chiropractors use drop table?
What is the physical storage length of time data type?
Is the primary key a clustered index?
What is netezza database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What r the comman abends in db2, jcl and cobol???????
What is the use of runstats in db2?
Define declaration generator (dclgen).
Define db2 and its databases?
Can we update view in db2?
