What is index cardinality?
- 3 Answers
- 10239 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 |
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
can any one expalin check point with an example?
What is a db2 collection?
What is null indicator in cobol db2?
What is db2 optimizer?
How can you classify the locks in db2?
How does coalesce work?
What is cursor?
In terms of DB2 indexing, what is the root page?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What does the CHECK Utility do ?
How to solve S0C7 abend with out using DISPlay in 10 mins?
COBOL 
