Interested to Buy Any Domain ? << Click Here >> for more details...
What is index cardinality?
- 3 Answers
- 11024 Views
- I also Faced
- E-Mail Answers
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 |
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is bind and rebind in db2?
How do I import data from excel to db2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is the result of open cursor statement?
What is explain plan in db2?
i want to delete 20th million record how ?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
How can you display the current date & current time ?
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?
COBOL 
