What is index cardinality?
Answers were Sorted based on User's Feedback
Answer / dave ian
the number of UNIQUE values for a column or columns, which
are part of an index.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
Cardinality is the number of distinct values for a given
column or group of columns.
FIRSTKEYCARDF contains the cardinality of the leading
column in the index
FULLKEYCARDF contains the cardinality of all the columns in
the index
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / 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 |
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is image copy?
how do you resolve -805?
Could anyone clearly explain the diference between sub query and correlated sub query?
How do we specify index to include or not during bind process.
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What does an outer join do?
How do I change the column size in db2?
What are the Isolation levels possible ?
What is correlation names?
What are catalog tables in db2?
What is node in db2?